| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable to formula.
Howdy all.
A quick and simple question.(My brain isn't working 2day) I have a workbook file name defined as a variable. I've tried to use the variable with-in a formula, and you guessed it, it didn't work. How would i be able to use the value defined in a variable, with-in a formula? Your assistance is !greatly! appreciated. Cheers from the "Land Down-under" :-) Russell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable to formula.
Russell
wbk = "book2" ActiveCell.Formula = "=[" & wbk & "]sheet1!c2" Tony -----Original Message----- Howdy all. A quick and simple question.(My brain isn't working 2day) I have a workbook file name defined as a variable. I've tried to use the variable with-in a formula, and you guessed it, it didn't work. How would i be able to use the value defined in a variable, with-in a formula? Your assistance is !greatly! appreciated. Cheers from the "Land Down-under" :-) Russell. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| variable formula | Excel Worksheet Functions | |||
| Variable VBA Max Formula | Excel Discussion (Misc queries) | |||
| Variable within a formula | Excel Worksheet Functions | |||
| Using a variable in a VBA formula | Excel Discussion (Misc queries) | |||
| Using a second variable within a formula... | Excel Discussion (Misc queries) | |||
Hybrid Mode
