Dynamic Camera (indirect reference) Trouble

[JCamara]

I can't make indirect references in the camera tool!

Lets say I name some ranges "triangle", "square" and "circle" and inside I put respective shapes.

If I create a "camera window" (or wtv) and change it's formula to "=square" it will work. If I use the mouse to pick up or type the specific range it'll also work.

Now, let's say i made a dropdown list on cell "A1" with the options "triangle", "square" and "circle".
I want to make the image change as i change the list, it's supposed to be easy.

So I change the "camera window" formula to "=INDIRECT(A1)" expecting it'll show me the range that's written on cell "A1". Instead i get an error saying that the value i typed is "not a valid reference"...

Any idea? Thanks in advance.

 

[pgc01]

Hi

You cannot use formulas when edit the shape formula

Create a name, for ex.:

Name: ImgRange
Scope: Sheet1
Refers to: =INDIRECT(Sheet1!$A$2)


and then use the formula

=ImgRange

 

[JCamara]

Thank you!

 

[pgc01]

You're welcome.