1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Excel Vba Move Down To Next Visible Cell

[Solved] Excel Vba Move Down To Next Visible Cell | Vb - Code Explorer | yomemimo.com
Question : excel vba move down to next visible cell

Answered by : cheerful-chipmunk-8rcht0sqo1mk

' 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 : https://www.ozgrid.com/forum/index.php?thread/55033-move-down-one-cell-in-an-active-filter/&postID=521468#post521468 | Last Update : Thu, 23 Sep 21

Answers related to excel vba move down to next visible cell

Code Explorer Popular Question For Vb