Size of filtered list

[Marvin Buzz]

I am filtering a list to an additional location requesting unique records
only. Is there an easy way to determine the size of the list?

Thanks.

 

[Bob Phillips]

Just use a normal technique to get to the bottom, SUCH AS

LastRow = Cells(Rows.Count,"B").End(xlUp).Row

and then get the visible rows

Set rng Range("B1").Resize(LastRow).SpecialCells(xlCellTypeVisible)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Marvin Buzz]

Bob-

I am not sure I understand your solution. Assume the address of the
extracted data is "$b$8" and there is data above and data below (say source
contains 100 rows) (let's say data exists in "$b$200").

Would your solution work in this scenario.

 

[Bob Phillips]

What is extracted data in this context?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)