Thread: How to substitute value of stringvariable to ActiveCell.FormulaR1C
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
robo robo is offline
external usenet poster
  
Posts: 3
Default How to substitute value of stringvariable to ActiveCell.FormulaR1C
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
Reply With QuoteReply With Quote