/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 vote141 views1 answer
Change "location" of binding navigator vb
VBA
0 vote159 views1 answer
.net crash app
VBA
0 vote150 views1 answer
Excel vba cell on change
VBA
0 vote186 views1 answer
Set datetimepicker value to null vb
VBA
0 vote149 views1 answer
Vba compare strings
VBA
0 vote152 views1 answer
Vba integer to double
VBA
2 votes102 views1 answer
Excel vba pause
VBA
0 vote151 views1 answer
Nested if else in vb.net
VBA
0 vote142 views1 answer
Excel vba address not absolute
VBA
0 vote149 views1 answer
Remove last 8 characters from string vb
VBA