Thank you so much, I did the change and found the numbers I needed for the debug to not come up and seem to work, but it still is showing the multiple empty rows on the new document.
I'm at a loss, and no one knows how the person before me did it, I am obviously not a microsoft expert!