/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 vote191 views1 answer
Regex numeric digits
VBA
3 votes228 views2 answers
Excel "vba" match last value
VBA
0 vote180 views1 answer
Excel vba linter
VBA
4 votes176 views1 answer
Excel vba how to reset usedrange
VBA
0 vote253 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote185 views2 answers
Vba remove line breaks
VBA
0 vote186 views1 answer
Excel vba unmerge sheet
VBA
0 vote180 views1 answer
Not allow form to be resized
VBA
1 vote161 views1 answer
Vba compile error object required
VBA
0 vote185 views1 answer
Vba copy file
VBA