visible row count after autofilter

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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?


  • Re: visible row count after autofilter


    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!