/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

2 votes109 views1 answer
Date format for ms chart vb.net
VBA
0 vote119 views1 answer
Vba line feed
VBA
0 vote107 views1 answer
Handling a click event anywhere inside a panel vb
VBA
31 votes169 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote124 views1 answer
Excel vba delete folder
VBA
1 vote120 views1 answer
Vba optional
VBA
0 vote121 views1 answer
Discern between file and folder given path vb.net
VBA
1 vote116 views1 answer
Excel vba close form escape key
VBA
0 vote135 views1 answer
Vba multiple optional arguments
VBA
6 votes121 views1 answer
Excel vba get the path of current workbook
VBA