/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

3 votes175 views1 answer
Vba folderexists
VBA
1 vote178 views2 answers
Get all column names from excel vba
VBA
0 vote165 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote180 views1 answer
Vba find last column in a row with data
VBA
-1 vote181 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote180 views1 answer
Vba excel do not recalculate before save
VBA
25 votes223 views2 answers
Excel vba folder exist
VBA
0 vote184 views1 answer
Make your computer talk vbscript
VBA
20 votes238 views1 answer
Excel vba factorial
VBA
0 vote135 views1 answer
Vbide vbproject reference
VBA