Hi Garry,

Am Wed, 24 Sep 2014 08:56:37 -0400 schrieb GS:

I like to reflect the logic in my formulas, though I do hate using
cell addresses! You have a knack for brevity that I also like, but
I find using named refs easier for users to understand what a
formula does!

I don't know anything about the knowledge and the preferences of the
OP. And I guess it is easier for a specialist to change the cell
addresses with range names than for a layman to change names to cell
addresses. For myself I use names also.


Regards
Claus B.

Typically, names reflect headers so users know which col is being
ref'd. Usually these names are col-absolute/row-relative.<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion