Thread: Hide Columns When Printing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] barbetta3141@yahoo.com is offline
external usenet poster
  
Posts: 20
Default 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"

Reply With QuoteReply With Quote