Hide Columns When Printing
 

I would like help on how to view show columns when working on a worksheet,
but hide them when I print my worksheet. Can anyone help please?

Thanks!

Hide Columns When Printing
 

Try one of

Range(myRange).EntireColumn.Hidden = True
Range("B1").EntireColumn.Hidden = True
Columns("A:E").Hidden = True

Then one of
ActiveSheet.PrintOut
ActiveSheet.Print

Then the same line as above but with "=False"

Hide Columns When Printing
 

See
http://www.rondebruin.nl/print.htm#Hide

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Heather" wrote in message ...
I would like help on how to view show columns when working on a worksheet,
but hide them when I print my worksheet. Can anyone help please?

Thanks!