HELP - This Macro works on small amounts of data but fails on large amounts

Hello everyone,

I have a macro that works fine on a sheet containing 3,000 rows yet on another that contains 20,000 rows it fails.

Can someone advise a way to enhance this macro or why it fails?

The macro has to search sheet1 for a specific name in a field (E.g. John) and then copy that row into sheet2 then return to sheet1 and find the next occurrence of the name "John". It then again copies that row and then return to sheet2 and adds that row on the row below the last.

Simply put the purpose is to extract all rows from columnA that contain "John" and paste them into sheet2.

Here is the macro I have been using:

Please Login or Register  to view this content.

------------------------

Many thanks for any help or answers.

Thanks for the tips too!

Saying something fails is not helpful, neither are terms like doesn't work or crashes.
Please be specific, do you get an error? If so, what is the error, what are the values of your variables when you get the error, etc. etc. etc.

One possibility but if it's only 20,000 or so rows is your integer variable types. Change them to long, if that doesn't fix it you need to go into detail.


Also to conform with the board rules wrap your code in code tags.
Highlight all the code click on the # icon and save changes.
Thanks.

Please Login or Register  to view this content.

Please read #3 in the Forum Rules.

Hi..

Try this one too...

Please Login or Register  to view this content.