/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

1 vote206 views1 answer
Excel vba saveas force overwrite
VBA
0 vote229 views1 answer
Find if year is leap year vb
VBA
0 vote223 views1 answer
Send text to clipboard vb.net
VBA
0 vote218 views1 answer
Write listbox to text file vb.net
VBA
0 vote221 views1 answer
Excel vba combine ranges
VBA
3 votes241 views1 answer
Extract word in a text in excel
VBA
0 vote266 views1 answer
Vba dictionary clear
VBA
1 vote209 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote198 views1 answer
Vba remove numbers from string
VBA
0 vote275 views1 answer
Vba is integer
VBA