Good afternoon all,
Is there a way to limit the number of rows to be used (pasted) by the advanced filter?
I have a macro that runs the advanced filter and I want to be given only 3 rows of results, no matter how many valid data is found in the source. This is because I have other data below, on the same sheet, that I don't want to be overwritten no matter what. I have manually selected that target range, but when there are more than 3 valid results I get the message "The destination range is not large enough to accommodate all copied rows. Data below the destination range will be lost. Continue copying anyway?"
I'm using the code below and thought the EnableEvents = False code would stop the warning message, but it doesn't.
Please Login or Register to view this content.
Is there a way?
Thank you all in advance.