| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro to print a selected range, not entire worksheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to change validation list and print | Excel Discussion (Misc queries) | |||
| print only selected cell contents without loosing spread sheet for | Excel Discussion (Misc queries) | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Perform oiperations relative to initial selected cell | Excel Discussion (Misc queries) | |||
| print entire workbook default | Excel Discussion (Misc queries) | |||
Threaded Mode
