Hi
Dim NameB as String
NameB = NameA

in a cell you could have
range("A1").Value = NameB

would now have content "BLA BLA"

regards
Paul
On May 21, 12:35*pm, Joe wrote:
I tried searching, but no use!

I have a Const NameA = "BLA BLA"
I have a variable NameB

Value of NameB is NameA.
How do i get the text "BLA BLA" from NameB variable

Is there anyway to do that?

something like,, * VALUE(NameB)

Thanks & Regards
Joe