Workbook.Variables?

  • Thread starter Thread starter Sonny Maou
  • Start date Start date
S

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. ;) )
 
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 said:
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
Click to expand...

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