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.
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.