I figured out what was happening. I showed the userform from the
on_open sub of the workbook and on the line after I showed the userform
was the line where I blanked out my range reference. I moved this line
above showing the user form and now it resets my print range, opens the
user form and lets the user form redefine the print range.

I thought I was going crazy for a bit but after some very close step by
step investigation (and a few days away from it) it all was clear to
me.


Scott