Hi
have a look at
http://www.contextures.com/xlautofilter03.html#Count
to count the number of returned rows. Maybe this will help you

--
Regards
Frank Kabel
Frankfurt, Germany

Hi,

I'm no expert in VBA, but with simple recording I have made a little
program that selects certain records form a excel table and
copy/pastes it into another file. But it is running slow, because it
also copies and pastes only the header line, when there are no
records selected for the filter it was told to filter, this is not
necessary and time consuming.

In my Macro I want excel to understand when it is told to filter on
something that does not exist in the excel Table it should not copy
Ctrl-*(current.region) and paste it in another file.

Is this possible. Despite buying a big book I was unable to find this
back.

Leo


---
Message posted from http://www.ExcelForum.com/