Name conflict error due to shape assigned with macro that needs arguments

[siva1612]

I have a worksheet which has a shape assigned with a shape. The shape is assigned to a sub routine which requires a parameter.

I have assigned the macro as 'SubRotineName(Parameter)' (Including the single quotes)

The macro works fine when I'm clicking it. But, when i try to change the reference style between R1C1 to A1, it throws a name conflict error.

Regardless of whether the reference style is A1 or R1C1, before I try to change the style, the same error appears.

Can anybody help why this happens and how to avoid it?

[xlnitwit]

Hi,

To the best of my knowledge, this capability has never been officially documented- as mentioned here http://www.tushar-mehta.com/excel/vb...0arguments.htm

That means that I doubt you will find a definitive answer as to why this happens. If you need to change reference styles I suggest you use an alternative method to pass the argument such as the Alt Text of the shape, or including it in the name. You should also know that if you save the workbook in .xlsb format, it will be regarded as corrupt when you try to reopen it if you have any shapes using this method.