Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to substitute value of stringvariable to ActiveCell.FormulaR1C
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. "RoBo" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( | Excel Discussion (Misc queries) | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format | Excel Programming | |||
SUBSTITUTE | Excel Worksheet Functions | |||
Substitute chr(39) | Excel Programming |