ActiveWorkbook.Names.Add - using Cell Value as an input to "RefersTo"

[vidyuthrajesh]

i would require the input for "RefersTo" to be taken from a call value. The following code does not work. Can i get help with right syntax / logic please..

Please Login or Register  to view this content.

So "Cat" should refer to A2:A25

Thanks.

[vidyuthrajesh]

Apologies for typing the code wrongly

i would require the input for "RefersTo" to be taken from a call value. The following code does not work. Can i get help with right syntax / logic please..

Please Login or Register  to view this content.

So "Cat" should refer to A2:A25

[XOR LX]

Hi,

Amend in part to:

Please Login or Register  to view this content.

Regards

[vidyuthrajesh]

Most perfect. Thanks.

[XOR LX]

You're welcome.