/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

4 votes285 views1 answer
Excel vba check cell not empty
VBA
0 vote267 views1 answer
Excel vba milliseconds
VBA
0 vote290 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote288 views1 answer
Select case vba
VBA
1 vote302 views2 answers
Vba string length
VBA
0 vote270 views1 answer
Excel vba hide columns
VBA
0 vote328 views1 answer
Visual basic run command
VBA
0 vote283 views1 answer
Vba word pdf table to excel
VBA
0 vote313 views3 answers
Write to text file vb.net
VBA
0 vote291 views1 answer
Excel text to columns line break
VBA