Martin Fishlock
12/20/2006 5:11:00 AM
Digger:
You just need to use the entirerow as in:
Range("A1:A6").SpecialCells(xlCellTypeVisible).EntireRow.Select
BTW you don't need select selection you can do in with the range object.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
"mf_digger" wrote:
> 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
>
>