Quote Originally Posted by c7015
the whole thing just crashes
You have to reboot the computer? Reboot Excel? What? Is there any error message - what does it say?
Quote Originally Posted by c7015
But it seems like its on the second find it command after I change sheets
What makes you say it seems its on the second find it?
Quote Originally Posted by c7015
I was hoping there was a way to loop the first set of code with a new range On the summary page
There is but I need to understand what crashes it first.
Can you attach the file here?