Macro to print a selected range, not entire worksheet

[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 only my selection is sent to the printer?

Thanx.

- Jim

[comotoman]

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

[Dave Peterson]

What do you have selected when you run the macro?



James C wrote:
>
> 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 only
> my selection is sent to the printer?
>
> Thanx.
>
> - Jim
>
> --
> James C
> ------------------------------------------------------------------------
> James C's Profile: http://www.excelforum.com/member.php...o&userid=12114
> View this thread: http://www.excelforum.com/showthread...hreadid=477618

--

Dave Peterson

[James C]

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