Selecting and printing cells from different sheet

[hurleypa2002]

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.

 

[VoG]

Try

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

 

[hurleypa2002]

Thanks Peter!

Worked!

Pat.