/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 vote382 views1 answer
Test if form is open vb
VBA
1 vote364 views1 answer
Excel format cell as kilowatts
VBA
0 vote365 views1 answer
Vbnet click on dgv cells
VBA
-1 vote359 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote367 views2 answers
How to concatenate more than 40 lines in vba
VBA
4 votes360 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote345 views1 answer
Vb net show lines for all axis labels in chart
VBA
22 votes865 views1 answer
Excelvba check for directory
VBA
0 vote349 views1 answer
Excel vba show developer tab
VBA
0 vote352 views1 answer
Set column width of datagridview vb.net
VBA