Absolute

[Kai90]

Hello,

I am using a macro, in which I define the following:

Set RedLight = ActiveSheet.Shapes("Oval 1")

However, I would like to change it from any active sheet to an absolute worksheet, e.g. a worksheet named RAN_CHART

How can I incorporate this? I tried:
Set RedLight = RAN_CHART!.Shapes("Oval 1")
But it gives me an error message.

Thanks a lot.
Kai

 

[Smitty]

How about:

Set RedLight = Sheets("RAN_CHART").Shapes("Oval 1")

Hope that helps,

Smitty

 

[Kai90]

Thanks you

That works perfect.
Thank you so much.
Kai