Code referencing another Cell

[vzwtester]

Hello,

Is it possible to reference code in another cell? I'm looking to change code in one cell and it reflects in others. I want to change B2:B16 in A2 and it change the B2:B16 in C2,E2,and G2. Is this possible?

Here is the exact code I have in the following cells.

Please Login or Register  to view this content.

[Ace_XL]

Perhaps use 'named ranges'

http://www.contextures.com/xlNames01.html

This will automatically update all ranges once the 'named range' is edited

[vzwtester]

I didn't think of that. I named a range, but I'm unsure on how to add it into my formulas?

[vzwtester]

I'm not sure if a named range is going to work if I understand it correctly. I have D9 named to August.

In D9, I have B45:66

I changed the formula to

Please Login or Register  to view this content.

which returns 0. This is not correct. I think the named range needs to be a value?

[Norie]

Use INDIRECT.

For example if you had B45:B66 n D9 and you wanted that to replace B2:B16 in the formulas.

Please Login or Register  to view this content.

[vzwtester]

That works perfectly! Thank you.