Well then I guess you're right and I do "have no idea on what" I am doing, but maybe that's why I'm here?
I have another macro that does a bunch of stuff, and the Dim char As Range goes towards formatting tables. It's over 500 lines of code and on another PC, so even if I knew how to provide it here, not knowing what could be causing the problem at all and just posting the entire macro seems silly.
When I added gmaxey's code into the beginning of my other macro, it just skipped it altogether, no error messages or anything broken. The only thing I could think was that maybe having 2 x Dim something As Range might cause a problem, but I didn't think it would.
|