Referring to cells by range names

R

rllane47

yes, correct on the two spaces vs one. one is sufficient.

however, i still cannot make the formula work without indirect an
using quotes for the range names.

i have enjoyed the help and the spirited discussion
 
R

RagDyeR

Shot in the dark.
This may be a version issue.
Try:
<Tools> <Options> <Calculation> tab,
And check "Accept Labels In Formulas".

Tell us if that works.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


yes, correct on the two spaces vs one. one is sufficient.

however, i still cannot make the formula work without indirect and
using quotes for the range names.

i have enjoyed the help and the spirited discussion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referring to cells by range names 3
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Consolidate by range names which represent worksheet tab names 4
Referring to cells by range names 2
Chart data - Range Names 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
SUMIF-how do i get it to work using names in range?help 3
How do I remove spaces at the beginning of cells? 3

Top