Macro to print a selected range, not entire worksheet

  • Thread starter Thread starter James C
  • Start date Start date
J

James C

Hello all,

I have recorded a macro of the user selecting a range, then going File
Print, Selection, Ok.

For some reason, the recorder collects the following line:
Selection.PrintOut Copies:=1, Preview:=True, Collate:=True

Running the macro results in my entire worksheet being printed

Unless I am missing something, how can I tweak this line so that onl
my selection is sent to the printer?

Thanx.

- Ji
 
You need to define your print range, if it is the same, re-record you
macro and while recording select and set your print area
 
Guys,

Thanks fot your feedback. I recorded a fresh session and it works fine.
I had a print preview in the first recording that just screwed things
up.

I am all set.

Thanks.

- Jim
 
Back
Top