Menu

Setting a print range using variables

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

Mary Branson Mary Branson is offline

Mary Branson is offline

external usenet poster

Posts: 2

Default

Setting a print range using variables

(Mary Branson) wrote in message . com...
I would like to write a macro using VBA to set print ranges
dynamically.

Here's the code I finally used (I will substitute variables in for the numbers):

ActiveSheet.PageSetup.PrintArea = Range(Cells(1, 1), Cells(22, 50)).Address

Thanks for all the help!

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting up a variable print range	Gary[_5_]	Excel Programming	5	July 31st 03 04:32 AM
Setting print range using VBA	Dave Ramage[_2_]	Excel Programming	0	July 29th 03 04:35 PM
Setting print range using VBA	VBANut	Excel Programming	0	July 29th 03 04:20 PM
Setting print range using VBA	Ron de Bruin	Excel Programming	0	July 29th 03 03:59 PM
Setting Print range	Tom Ogilvy	Excel Programming	3	July 25th 03 04:06 AM

All times are GMT +1. The time now is 06:42 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement