Hi,

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

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

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

Le

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