/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 votes151 views1 answer
Excel vba extract file name
VBA
0 vote170 views1 answer
Vba table header name
VBA
0 vote151 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote164 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote162 views1 answer
Vba sort multiple columns
VBA
0 vote146 views1 answer
Excel vba show developer tab
VBA
1 vote156 views1 answer
Excel vba first and last row and column in range
VBA
1 vote161 views1 answer
Excel vba force recalculation
VBA
2 votes149 views1 answer
Date format for ms chart vb.net
VBA
6 votes170 views1 answer
Excel vba get the path of current workbook
VBA