Hi,

I need to capture only those rows which are visible in xls (but not hidden)
in my macro. Could some one plz help me in this regard. I

I understand how to select only the visible cells (shown below) but how can i
capture the rows or row number only for the visible cells.

for eg:

Range("A1:A6").Select
Selection.SpecialCells(xlCellTypeVisible).Select

Thanks
digger