Home » Forums » Open Source Learning Center » Question and Answer

Need help in selecting a cell after filter

Submitted by anish_kurian on 19 May, 2013 - 05:24

hi experts,

can anyone help me in vba code to select next visible cell below the header.

after filtering i need to select next visible cell below a1(header cell).

thanku

‹ Create a list for specfied person from long list Named ranges as data-input for excel charts ›
»
Almir's picture

Try this:

Submitted by Almir on 3 June, 2013 - 20:37.

Range("A4:A12").Select ' example of filtered range where column header is in A1, and A2 and A3 are hidden by filter

Selection.SpecialCells(xlCellTypeVisible).Select

»