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