Print column same workbook different worksheet

Folks,
I need to print from sheet1 the column IZ in sheet 17
Frank FreeseAsked:
Who is Participating?
 
Harry LeeConnect With a Mentor Commented:
You can attach this to the Print button.

    Sheets("Sheet17").Columns("IZ:IZ").PrintOut Copies:=1, Collate:=True

Open in new window

0
 
Harry LeeCommented:
What do you mean by print? Printing to the printer?
0
 
Frank FreeseAuthor Commented:
Printing to a printer.
I will have a command button "Print" in sheet1 where I need to print in sheet17 column IZ range IZ1:IZ28
0
 
Frank FreeseAuthor Commented:
OK!
I had my PrintOut at the beginning
Appreciate your help
0
 
Frank FreeseAuthor Commented:
great job
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.