How to substitute value of stringvariable to ActiveCell.FormulaR1C

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have built a stringvariable in VBA with a VLOOKUP formula in it (the
tablearray refers to another file that has been input by a GetOpenFilename).
The ActiveCell.FormulaR1C1 = strFormula does not seem to work. How do I get
this
stringvariable substituted in the ActiveCell.FormulaR1C1 = ?
Thanks for your help and suggestions.

Ron
 
First, you have to confirm that the string you are passing to the variable
"strFormula"
has the proper sintax. Try displaying it using:
Msgbox(strFormula ) and verify sintax. You may want to post a larger portion
of your code in order to get a better feel of what may be causing the issue.


Michael Arch.
 
Back
Top