Row count a filtered sheet
rng.SpecialCells(xlCellTypeVisible).Rows.Count
where rng is the range that you have filtered.
--
HTH
Bob Phillips
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Peter" wrote in message
ps.com...
I have written a code that will filters a sheet however I now need to
count the rows that come out of the filter. Is there any way to do
this?
Thanks,
Peter
|