Variable to formula.

  • Thread starter Thread starter russell \(skmr3\)
  • Start date Start date
R

russell \(skmr3\)

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.
 
Russell

wbk = "book2"
ActiveCell.Formula = "=[" & wbk & "]sheet1!c2"
Tony
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[EASY] I'll become mad ' & "" in variables 2
Defining public/global variables in more than one place 1
Using Date as a Variable 3
How to use a variable as an argument in .FliiDown 4
Display value of a VBA variable inside a cell 2
Variable Range Copy... 13
Variable Not Defined 3
Inserting formulas depending on a variable 2

Back
Top