Workbook.Variables?

[Sonny Maou]

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

 

[John Green]

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

 

[Frank Kabel]

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

 

[Sonny Maou]

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).