/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 vote208 views2 answers
Excel vba number format file size
VBA
0 vote231 views1 answer
VBA Sort RossetaCode
VBA
1 vote199 views1 answer
Excel vba get column name from number
VBA
2 votes218 views1 answer
Vba file from path
VBA
0 vote200 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote212 views1 answer
Vba apostrophe chr
VBA
0 vote214 views1 answer
VBA Loop to range
VBA
0 vote215 views1 answer
Putting marquee in vb.net
VBA
0 vote197 views1 answer
Vba add month to date
VBA
0 vote205 views1 answer
Vbs
VBA