Macro to print a selected range, not entire worksheet

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
 
C

comotoman

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing to seperate printer trays................... 1
Print from Command Button Range 8
Macro (Print) - Calling Named Ranges 1
Autofilter turn off with macro 3
Macro to restrict printing to black and white 2
including entire worksheet sort in a macro 2
Macro for multiple prints 4
Print worksheet 2 on back of worksheet 1, etc.... 1

Top