Posted to microsoft.public.excel.programming

Mike[_122_] Mike[_122_] is offline

external usenet poster

Posts: 2

Setting Print Area

Hi,
Is it possible to set/reset the print area according to a cell value?

e.g.:-
if A1 = 1 then set print area to B1:B10
if A1 = 2 then set print area to C1:C10
etc.
TIA
Mike

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 The Print-Area ?	Robert11[_3_]	New Users to Excel	2	May 31st 09 03:24 PM
Setting The Print Area	beans_21	Excel Programming	3	January 10th 06 09:32 AM
setting a print area	Matilda	Excel Programming	2	November 13th 05 07:45 PM
Setting Print Area	dolppm	Excel Programming	2	March 8th 05 09:35 PM
Setting print area	Don Guillett[_4_]	Excel Programming	0	September 4th 03 02:14 PM

All times are GMT +1. The time now is 04:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us