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