WHERE DO YOU ENTER THE CODE SO I DO NOT KEEP HAVING TO HIDE THE ONE COLUMN I
DO NOT WANT PRINTED?

THANKS

"Bill Pfister" wrote:

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?