/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 vote166 views1 answer
Excel vba extract year
VBA
0 vote165 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote172 views1 answer
Vba table header name
VBA
0 vote170 views1 answer
Vba vbcrlf chr
VBA
0 vote161 views1 answer
Dynamic array vba
VBA
0 vote155 views2 answers
Excel vba close without saving
VBA
0 vote161 views1 answer
Vba first line of string
VBA
0 vote157 views2 answers
Delete all controls from list of control vb.net
VBA
8 votes239 views1 answer
Vba make integer
VBA
0 vote118 views1 answer
Vba set vs dim
VBA