/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 vote208 views1 answer
Do while not vb.net
VBA
2 votes192 views1 answer
Excel vba check if key is in collection
VBA
3 votes223 views2 answers
Vba date to string
VBA
1 vote213 views1 answer
Excel vba to lower case
VBA
0 vote215 views1 answer
.net crash app
VBA
0 vote189 views1 answer
Excel vba hide columns
VBA
1 vote193 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote228 views1 answer
Vba registry settings
VBA
6 votes201 views1 answer
Excel vba isalpha
VBA
0 vote193 views1 answer
Return na vba
VBA