Thanks guys for the follow ups. Firstly, the new error was associated with the same line of code.
I had the Dim outside but moved to within the loop. If I move to outside the loop the error is the same. I moved to within the look because I tried recreating a couple of incremental variables...