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!

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"

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

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


"Heather" <Heather@discussions.microsoft.com> wrote in message news:1ECD510D-CF24-44AA-8F78-CFDABC029AA3@microsoft.com...
>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!