Dave

When I press the Command Buttom the print preview only shows one of the
pictures I inserted into to worksheet named "CutSheet". No text etc.

The code is as follows:

Private Sub CommandButton1_Click()

Worksheets("CutSheet").Range("a1:a43").PrintOut _
Copies:=1, Collate:=True, preview:=True
End Sub

--
Garyw


"Dave Peterson" wrote:

Worksheets("Summary").range("a1:a43").PrintOut _
Copies:=1, Collate:=True, preview:=true

(Preview:=true will save a few trees when you're testing.)

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

--

Dave Peterson