add
Worksheets("Summary").PrintArea = "$A$1:$A$43"

"Garyw" wrote:

I've attached Macro to a Command Button in one worksheet called
"Worksheet"which I need to print a range in another worksheet called
"Summary". I have so far this line:

Worksheets("Summary").PrintOut Copies:=1, Collate:=True

Where do I add the range A1:A43?

Garyw