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

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

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

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/