Home > Mobile >  Selecting first and next cell in filtered criteria range
Selecting first and next cell in filtered criteria range

Time:10-03

I want to select next cell in Filtered range using VBA

For example, Column A having set of values and column B having set of values, I have to filter column B and criteria is Sunday for eg.,

for Sunday I want to re-write as Noted down.

I tried this code also With ActiveSheet.AutoFilter.Range Range("B" & .Offset(1, 0).SpecialCells(xlCellTypeVisible)(1).Row).Select

End with

I am getting error of Application defined or object defined error.

We cant even simply move to next cell in filtered range? Any easy way is there to move to first and next cell in filtered criteria?

enter image description here

  • Related