Thread: Printing
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bill Pfister Bill Pfister is offline
external usenet poster
 
Posts: 132
Default Printing

Sub PrintSomeStuff()
Dim wkb As Workbook
Dim wks As Worksheet

Set wkb = ThisWorkbook
Set wks = wkb.ActiveSheet

wks.Columns("B:Y").Hidden = True
wks.Columns("A:Z").PrintOut
wks.Columns("B:Y").Hidden = False

End Sub



"rachelk" wrote:

Yes, please

"Bill Pfister" wrote:

Hide columns B to Y, then select A to Z and print. Need the code?


Bill


"rachelk" wrote:

I need the ability of printing everything in Column A next to everything in
Column Z without printing all the columns in between. How do I do this?