Feeling good but...help with last row

So I've finally been able (after several days of searching) to come up with and modify VBA code that will look for "Y" in column Q of three worksheets and copy the entire row to another worksheet ("!!").

My problem is with z = 3000

I'm trying to reduce the amount of processing it takes to find the data I want and make this code the simplest I can.

I've looked and tried several examples but can not get a last row search, instead of specifying the last row as 3000. Eventually I will have to search more than 3000 rows for the information I want.

Any help is appreciated.

My code:

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have added them for you today. Please read all Forum Rules and comply in the future.)

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and on closer look, I think you need to move it to right after your line of code

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Amazed you didn't get asked to change the thread title but I guess "help with last row" covers it.


Regards, TMS

You're welcome. Thanks for the rep.