/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

8 votes477 views1 answer
Vba make a short integer from two bytes
VBA
0 vote364 views1 answer
Vba html document reference
VBA
0 vote364 views1 answer
Vba round to 2 decimals
VBA
2 votes345 views1 answer
Vba split string
VBA
0 vote371 views1 answer
Vba sort the data Z to A
VBA
0 vote449 views1 answer
Vba vbcrlf chr
VBA
1 vote353 views1 answer
Excel vba saveas force overwrite
VBA
0 vote351 views1 answer
Vba type
VBA
0 vote363 views1 answer
Change form background image vb
VBA
0 vote360 views1 answer
Excel vba select multiple shapes
VBA