Quote Originally Posted by Trebor76 View Post
From Excel 2007 and on it's a good idea to not use an integer variable when referencing rows as its highest value is 32,767 as opposed to there being 1,048,576 rows in Excel 2007 and on.
Robert
Nice suggestion. I didn't even think about that. I hope I will keep that in mind.

I tried your code and it still takes the same amount of time to execute. Any other ideas? Does memory need to be cleared out or something?

Also, I noticed that in your code you turn off/then turn on screen updating. Is there an advantage to doing this?