Set Print Area

[djblois1]

I am using code to select a Print Area and it keeps only selection one cell and giving me an error. Here is the code:

Please Login or Register  to view this content.

I have tried many other ways and they all keep giving me the same problem. Thank you all for the help in advance.

[shg]

What are you trying to set the print area to?

[djblois1]

from range A2 to the cell that it finds in the find command. It will always be a different spot so I have to make it dynamic like I did.

[shg]

Try this:

Please Login or Register  to view this content.

[djblois1]

Thank you that worked perfectly.

How do you know a way to set the amount of copies? I want the print dialog to open with 12 copies already filled in?

[shg]

Try recording a macro, and we'll help you clean it up.

[djblois1]

I just did record a macro and this is what comes out:

Please Login or Register  to view this content.

That is not what I want because it does not bring up the print dialog box. I want to set the copies to 12 but bring up the print dialog box. Is this possible?

[shg]

Please Login or Register  to view this content.

[djblois1]

I already have that code. The issue is I want it to open with 12 copies already set. Is that possible?

[shg]

Don't think so.

[MarvinP]

Maybe you should do a .printpreview and change it to 12 by hand and then have it print.