Sorry to trouble you with something so trivial.

I have a workbook that contains a defined name (say, "MyName") which refers to a specific cell which contains a text string. The name is local to the worksheet containing that cell.

I have a VBA routine in which I wish to assign to a variable (say "stMyString") (DIMmed as String) the value of the text string contained in the cell to which MyName refers. I need to do this by reference to the defined name, not by reference to the cell itself, whose reference might change between separate instances of running the macro.

What is the syntax for that assignment statement, please?