| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. ;) ) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. ;) ) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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). :) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. ;) ) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| how to declare local variables for Excel.Workbook at runtime. | Excel Discussion (Misc queries) | |||
| Three Variables | Excel Worksheet Functions | |||
| Creating Linked Workbook file name using cell variables | Excel Worksheet Functions | |||
| referencing external workbook using variables | Excel Programming | |||
Hybrid Mode
