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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

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

Watch MrExcel Video

Forum statistics

Threads
1,109,081
Messages
5,526,729
Members
409,717
Latest member
Oscarsalone

This Week's Hot Topics

Top