Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filters and dynamic ranges
I have recorded a VBA routine that uses the Advanced filter (activated from
the menu) to filter a dynamic range with 5 columns and around 300 rows of data. It then copies the filtered data and pastes it into a another location. The problem is, if the filter comes up empty, instead of pasting one row of nothing, the cut and paste part of the procedure pastes 300 rows of "#ref" into the location. In this case writing over my database... Anyone have an idea about how to avoid this happening if the filtered data is an empty set? Thanks in advance, RD Wirr |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filters and dynamic ranges
If your using the advanced filter, then use the copy to another location
option. then you can delete the visible rows if anything is in the new location. -- Regards, Tom Ogilvy "RD Wirr" wrote in message ... I have recorded a VBA routine that uses the Advanced filter (activated from the menu) to filter a dynamic range with 5 columns and around 300 rows of data. It then copies the filtered data and pastes it into a another location. The problem is, if the filter comes up empty, instead of pasting one row of nothing, the cut and paste part of the procedure pastes 300 rows of "#ref" into the location. In this case writing over my database... Anyone have an idea about how to avoid this happening if the filtered data is an empty set? Thanks in advance, RD Wirr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Ranges | Excel Discussion (Misc queries) | |||
protect cell ranges in spreadsheet and have data filters on | Excel Discussion (Misc queries) | |||
protect cell ranges in spreadsheet and have data filters on | Excel Worksheet Functions | |||
Dynamic Ranges | Excel Discussion (Misc queries) | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions |