Finding the 1st row of a filtered set of data

[xlbo]

This was bugging me for ages cos I wanted to take all data EXCEPT the titles from a set of filtered data. Credit for this goes to Bob Umlas (Excel MVP) / CMMRoom and Dadofchamp from the excel L list

To get the 1st row of any filtered set of data, use the following code:

FirstRow =
range("A1&quot.CurrentRegion.SpecialCells(xlCellTypeVisible).Areas(2).Row
Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde