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