View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Garyw Garyw is offline
external usenet poster
 
Posts: 34
Default Print from Command Button Range

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