Selecting and printing cells from different sheet

hurleypa2002

New Member
Joined
Aug 12, 2004
Messages
31
Hello,

I am trying to select and print a group of cells in sheet2 when I run a macro in sheet 1...

Thought that I could just add one line of code in the macro on sheet 1 to get this to run and print but it doesnt seem to work...

Worksheets("Sheet2").Range("B2:C3").SelectSelection.PrintOut Copies:=1, Collate:=True

but it doesnt seem to work... trying to print cells B2,C2,B3 and C3...

brain fart....

Any help?

Thanks.

Pat.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

Code:
Worksheets("Sheet2").Range("B2:C3").PrintOut
 

Watch MrExcel Video

Forum statistics

Threads
1,108,730
Messages
5,524,492
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top