Thanx muchly!!! Worked perfectly....

sooooooo....how would I write a VBA code to do the same thing for columns then???

I copied your other code into my macro button, but how do I get it to hide columns that have nothing in them and unhide them after printing??

Thanx in advance and again for the last help