Workbook.Variables?
 

Word has Document.Variables. Does Excel have something analogous?
(Doesn't look like it, but I have to use every resource to confirm. ;) )

Workbook.Variables?
 

The closest to Word document variables in Excel would be Names. You can store a value in a name with code like the following:

Names.Add Name:="myValue", RefersTo:="myData"

The name can be used in cell formulas:

=myValue

--

John Green - Excel MVP
Sydney
Australia


"Sonny Maou" wrote in message ...
Word has Document.Variables. Does Excel have something analogous?
(Doesn't look like it, but I have to use every resource to confirm. ;) )

Workbook.Variables?
 

Hi
have a look at
http://www.cpearson.com/excel/docprop.htm

--
Regards
Frank Kabel
Frankfurt, Germany
"Sonny Maou" schrieb im Newsbeitrag
...
Word has Document.Variables. Does Excel have something analogous?
(Doesn't look like it, but I have to use every resource to confirm.
;) )

Workbook.Variables?
 

John Green wrote:

The closest to Word document variables in Excel would be Names. You can store a value in a name with code like the following:

Names.Add Name:="myValue", RefersTo:="myData"

The name can be used in cell formulas:

=myValue


Great! Thanks John (and to Frank Kabel, too). :)