Quote Originally Posted by p45cal
on which line does it crash?

It dosent return a line , the whole thing just crashes

But it seems like its on the second find it command after I change sheets


I was hoping there was a way to loop the first set of code with a new range
On the summary page