/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 vote170 views1 answer
Make your computer talk vbscript
VBA
0 vote168 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
1 vote175 views1 answer
Excel vba array remove first
VBA
1 vote164 views1 answer
Change the first item in a queue vb.net
VBA
0 vote174 views1 answer
Change form background image vb
VBA
1 vote178 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote175 views1 answer
Open file dialog in vb.net
VBA
0 vote159 views1 answer
Excel text to columns line break
VBA
0 vote169 views1 answer
Telephon call in vba
VBA
0 vote171 views1 answer
Excel vba urlmon
VBA