filter gives no output, no copying necessary of current.region

  • Thread starter Thread starter Leo Kurvink
  • Start date Start date
L

Leo Kurvink

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
 
Back
Top