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