View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Sonny Maou Sonny Maou is offline
external usenet poster
 
Posts: 18
Default 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). :)