philfer
03-16-2008, 11:54 AM
Hello,
I am using rows.count and a range object to see how many rows autofilter returns.
However, it keeps giving me the answer as three when I can see about 30 rows.
I am using xlvisiblecells
Has anyone come acress this before? and if so how did you solve it?
I am using rows.count and a range object to see how many rows autofilter returns.
However, it keeps giving me the answer as three when I can see about 30 rows.
I am using xlvisiblecells
Has anyone come acress this before? and if so how did you solve it?