(PeteCresswell) said:
Per Clif McIrvin:
Thanks.
Also, I stumbled on to something that at least *seems* like good
practice: assign a range name to the cell in question by typing
it in to the area to the left of "fx". Once that's done, the
range name will appear when selecting the cell for inclusion.
Makes formulas more verbose, but cuts down on the "magic numbers"
and arcane references.
e.g.
Instead of:
=(($F$7*$G$7*$B$2)/1000)*$B$1
One winds up with:
=((TvRackDraw*TvRackTimerHours*DaysPerYear)/1000)*KwHrCost
Yes, I've used that myself. Back in 2003, you could also define names
via the Edit | Names submenu (I think it was Edit ... don't have 2003
available anymore) ... I havn't looked for that in 2010 yet.
I believe I've read that in 2010 you can assign a formula directly to a
named label ... I can think of times I'd have loved to be able to do
that!
One issue I run into (I inherited many workbooks with "row data" [for
want of a better term] in sheets instead of rows) ... is that named
ranges become ambiguous as soon as I add the second sheet.
--
Clif McIrvin
Change nomail.afraid.org to gmail.com to reply by email.
(nomail.afraid.org has been set up specifically for
use in usenet. Feel free to use it yourself.)