visible row count after autofilter

  • HI, I am having an issue with counting the visible rows after an autofilter has been applied.



    lr works fine but vis_lr is not the right count.


    Can anyone assist in solving this please?


    Dave

  • Re: visible row count after autofilter


    SOLVED IT!!


    Code
    vis_lr = ThisWorkbook.Sheets("Air Data").AutoFilter.Range.Columns(1).SpecialCells(xlCellTypeVisible).Cells.Count - 1

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!