Keep a Formula in Print Area

G

Gary R.

Ok here is my problem, I know that setting the print area is the easiest solution but for some people I work with that could be to much, sad isnt it. Any way I have techs that fill out a route log saying where they have been for the day. I would like it set that if they select page 2 that it resest the print area. So it would only print the 1st or 1st and 2nd depending on what they set. I cant use any type of macros or anything a email server could consider a virus, so it pretty much just has to be the formula in the print area or something of that extent. My current formula is this =IF(AB4=2,B2:AO83,B2:AO45) But it wont stay. Im using Excel 2000. Any help would be great

Thanks
 
G

Gord Dibben

Gary

Formulas can only return values.

Cannot be used to set print areas.

If you cannot train your users to set a print area, perhaps you can set up
different Views of your worksheet and have your users click on one view or the
other.

See View>Custom Views and the Help files on this subject.

Also handy with Custom Views is the Report Manager Add-in.

Macros would be the easiest route to go. Too bad you can't/won't use them.

Gord Dibben Excel MVP
 
G

Gary R.

Thanks Gord

The company I work for will not allow macros to be emailed into the company. I guess I will just have to teach squrriels to eat nuts! lol
 
A

Arvi Laanemets

Hi

Maybe you would be more specific a bit? What is the table stucture your
techs are filling out? For what they have to select page 2? And what must
they do there? What the hell are 1st and 2nd? Are tech's sending their logs
into office per e-mail (otherwise I don't understand why you did bring your
mailserver into, but who knows)?

From that little you did give us here, I think you need a report sheet,
where data from source sheet are displayed respectively selected conditions.
You can do this using worksheet functions only. And maybe you even can
design it so, that you have an universal report workbook, where you can set
log file name you want to print out - so log files do contain a single table
only.

--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


Gary R. said:
Ok here is my problem, I know that setting the print area is the easiest
Click to expand...
solution but for some people I work with that could be to much, sad isnt it.
Any way I have techs that fill out a route log saying where they have been
for the day. I would like it set that if they select page 2 that it resest
the print area. So it would only print the 1st or 1st and 2nd depending on
what they set. I cant use any type of macros or anything a email server
could consider a virus, so it pretty much just has to be the formula in the
print area or something of that extent. My current formula is this
=IF(AB4=2,B2:AO83,B2:AO45) But it wont stay. Im using Excel 2000. Any help
would be great.
 
Top