Adding variables in a sheet reference?

[Paul Jolley]

Inside a shape sheet, if you have a refference to another shapes custom
properties for example

- Sheet.84!Prop.Row_1

Can you edit it so that the sheet ID (84) can be a variable taken from a
custom property in the current shape?
So it would take the form

- Sheet.[Prop.Row_1]!Prop.Row_1

I've tried the above, but it doesn't work.

Any ideas how to get this to work?

Thanks,

Paul

 

[Paul Herber]

On Fri, 6 Feb 2009 07:56:11 -0800, Paul Jolley <Paul

Inside a shape sheet, if you have a refference to another shapes custom
properties for example

- Sheet.84!Prop.Row_1

Can you edit it so that the sheet ID (84) can be a variable taken from a
custom property in the current shape?
So it would take the form

- Sheet.[Prop.Row_1]!Prop.Row_1

I've tried the above, but it doesn't work.

Any ideas how to get this to work?

In the absence of any other reply ... I don't think that syntax is
allowed. As far as I know there is no form of indirect access like
this.