/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 vote229 views1 answer
VBA Sleep Snippet
VBA
0 vote227 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote239 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote246 views1 answer
Excel filter by date not working vba
VBA
31 votes518 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote248 views1 answer
Selecttoken em vbnet e json
VBA
0 vote187 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote238 views1 answer
Excel vba copy range with filter
VBA
0 vote212 views1 answer
Excel vba disable alerts
VBA
0 vote235 views1 answer
Ribbon show/hide
VBA