Use of worksheet names in VBA

[Debu]

Hi ,

I am beginning to learn EXCEL Macros. I have defined a name XYZ = 10
in the workbokk. IS there a way to use this name in a VBA macro?

 

[JE McGimpsey]

One way:

myVar = Evaluate(Names("XYZ").Value)