/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

2 votes314 views1 answer
Vba round number
VBA
0 vote299 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote350 views1 answer
Vba ternary
VBA
4 votes318 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote306 views1 answer
Excel R1C1 mode
VBA
3 votes315 views1 answer
Vba request json
VBA
0 vote345 views1 answer
Excel vba set cell value to empty
VBA
0 vote304 views1 answer
Le contrôle SpinButton (Toupie)
VBA
1 vote342 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote287 views1 answer
How to make a if statement with vbs
VBA