How to Return Range value to message box

[kmbrady]

I have a text string stored in a cell that I need to show in a message box

Text is in cell 'e34' on sheet 'Tables'

I have also named cell 'e34' as 'TxT13'

If i refer to the cell as 'e34' this code works

Sub WITO()

If Sheets("Tables").Range("Prmt13") = "True" Then​

msg = Sheets("Tables").Range("e34").Value
​

MsgBox msg
​

End If​

End Sub

BUT
If I use the Range Name I get a blank message box

Sub WITO()

If Sheets("Tables").Range("Prmt13") = "True" Then​

msg = Sheets("Tables").Range("TxT13").Value
​

MsgBox msg
​

End If​

End Sub

I have attempted several variations but always get a blank message box,
' msg = Worksheets("Tables").Range("TxT13")
' msg = Sheets("Tables").Evaluate("TxT13")
' msg = Sheets("Tables").Range("TxT13").Value

Using the Range name does not return the text value to the message box. If I use the Name Manager to look at all my named ranges, the values are shown.

Suggestions?

 

[Beyond_avarice]

"TxT13" is not a valid Name. Excel should Autocorrect to "TxT13_"

Adjust your "msg" variable to match.

 

[kmbrady]

"TxT13" is not a valid Name. Excel should Autocorrect to "TxT13_"

Adjust your "msg" variable to match.

Thanks for the tip, adding the underline worked.

What is interesting is I'm testing a named Range (Prmt13) for a 'True' value, and it works without the underline at the end.
If Sheets("Tables").Range("Prmt13") = "True" Then ....

Thanks again