I want to use a cell Value as a named Range in a Formula
 

I was a value in a cell to represent the name of a range that I want to use
in a formula. Is there a function or way to do this in excel without VBA?

I want to use a cell Value as a named Range in a Formula
 

This seemed to work though I don't know if it is necessarily the best way.
As a test, I put some numbers in a range (C4:C8) added a formula to sum it
(for comparison purposes,) highlighted the range and named it using the name
box (MyRange,) put the word MyRange in cell D4, made another formula =sum(d4)
which as I suspected returned 0 and then changed it so that it read
=sum(indirect(d4)) and it returned the same value as the previously created
sum formula for comparison purposes.
--
Kevin Vaughn


"tmjones" wrote:

I was a value in a cell to represent the name of a range that I want to use
in a formula. Is there a function or way to do this in excel without VBA?

I want to use a cell Value as a named Range in a Formula
 

Thanks! That worked.

"tmjones" wrote:

I was a value in a cell to represent the name of a range that I want to use
in a formula. Is there a function or way to do this in excel without VBA?

I want to use a cell Value as a named Range in a Formula
 

You're welcome. Thanks for the feedback.
--
Kevin Vaughn


"tmjones" wrote:

Thanks! That worked.

"tmjones" wrote:

I was a value in a cell to represent the name of a range that I want to use
in a formula. Is there a function or way to do this in excel without VBA?