Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Predefined Print area based on variable
Here's what I've got...I have a sheet 60 cells wide broken into increments of
4 for a total of 15 sections. Each section correlates to a number in cell C2. If I place a 4 in C2 I would like excel to print only through section 4. I'd like to get away with this with no VBA code. I'm not sure any future personnel who may get this position will know how to edit it if need be. I've tried coding a nested If statement into the PrintArea block, but it won't take code there. Any suggestions. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Predefined Print area based on variable
Without VBA you could set up some Custom Views and have your users select from
those. Drag the Custom Views Icon to your Toolbar to make it simple for the users. Gord Dibben MS Excel MVP On Mon, 3 Mar 2008 13:40:00 -0800, CorporateQAinTX wrote: Here's what I've got...I have a sheet 60 cells wide broken into increments of 4 for a total of 15 sections. Each section correlates to a number in cell C2. If I place a 4 in C2 I would like excel to print only through section 4. I'd like to get away with this with no VBA code. I'm not sure any future personnel who may get this position will know how to edit it if need be. I've tried coding a nested If statement into the PrintArea block, but it won't take code there. Any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable print area via a macro | Excel Discussion (Misc queries) | |||
Set print area on variable range | Excel Programming | |||
variable print area? | Excel Programming | |||
Variable print area | Excel Discussion (Misc queries) | |||
Setting a variable print area | Excel Programming |