value of value of a variable.

Posted to microsoft.public.excel.programming

Joe[_46_]

external usenet poster

Posts: 48

value of value of a variable.

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning a Variable to an Expression that Includes a Variable andVBA Property	bluebird[_3_]	Excel Programming	3	April 27th 09 07:38 AM
Nothing Keyword Destories Objects rather than just resetting the variable to an empty variable	Ronald R. Dodge, Jr.[_2_]	Excel Programming	15	December 15th 08 09:19 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?	Daniel	Excel Worksheet Functions	1	July 9th 05 03:05 AM
Run-time error '91': "Object variable or With block variable not set	Mike[_92_]	Excel Programming	2	December 30th 04 10:59 AM
Cells.Find error Object variable or With block variable not set	Peter[_21_]	Excel Programming	2	May 8th 04 02:15 PM

All times are GMT +1. The time now is 07:44 PM.

Menu

About Us