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