taporctv
05-13-2008, 11:28 AM
I've been using the following code by sebastianm
http://vbaexpress.com/kb/getarticle.php?kb_id=127
I've encountered a problem when I try to copy the search results from the defined range to another sheets. For example, if I search the range that has 50 rows and it returns 10 rows, the macro has no problem pasting the results to thh other sheets. However, if the search returns all 50 of 50 rows of the range I get a run-time error '1004' / That command cannot be used on multiple selections. What can the problem be?
http://vbaexpress.com/kb/getarticle.php?kb_id=127
I've encountered a problem when I try to copy the search results from the defined range to another sheets. For example, if I search the range that has 50 rows and it returns 10 rows, the macro has no problem pasting the results to thh other sheets. However, if the search returns all 50 of 50 rows of the range I get a run-time error '1004' / That command cannot be used on multiple selections. What can the problem be?