Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - Copying to location other than current sheet? | Excel Discussion (Misc queries) | |||
Current region emulation | Excel Worksheet Functions | |||
Copy Current Region | Excel Programming | |||
Naming Current Region | Excel Programming |