/VBA/Excel vba move down to next visible cell

Excel vba move down to next visible cell

' Select the cell immediately above the filtered view
Range("A1").Select
' Move the selection to the first visible filtered cell of the same column
ActiveCell.Offset(1, 0).Select
  Do Until ActiveCell.EntireRow.Hidden = False
  ActiveCell.Offset(1, 0).Select
  Loop

Source: ozgrid.com

Similar codes

0 vote178 views1 answer
Vbnet find highest value in chart
VBA
0 vote118 views1 answer
Excel autofilter vba
VBA
2 votes186 views1 answer
Excel vba extract file name
VBA
0 vote175 views1 answer
Excel vba range contains
VBA
1 vote180 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote170 views1 answer
Vba add month to date
VBA
1 vote172 views1 answer
Excel vba make cell visible
VBA
1 vote189 views1 answer
Vba optional
VBA
0 vote182 views2 answers
Do until loop vba
VBA
1 vote179 views1 answer
Excel vba force recalculation
VBA