Print code

**laffers** · 07-23-2010, 04:26 AM

Is it possible to modify the following code to print a cell range on another sheet other than the active one?

Please Login or Register  to view this content.

**sweep** · 07-23-2010, 04:50 AM

Hi, something along these lines?

Please Login or Register  to view this content.

**laffers** · 07-23-2010, 05:19 AM

Cheers Sweep!!

Works a treat!

**royUK** · 07-23-2010, 06:39 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

UNNECESSARY WORDS REMOVED FROM TITLE

**bravo659** · 08-04-2010, 11:51 AM

I need to print sheet2 from sheet one with a button. This is an invoice i am trying to print.
The entire print area is from A1 through K1 down to A11 through K11?

Thanks appreciate it.

Desi

**royUK** · 08-04-2010, 12:46 PM

Desi

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

**bravo659** · 08-04-2010, 01:01 PM

Originally Posted by royUK

Desi

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Ok I will start a new thread.