Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 using variables
I want to do this but can't:
ActiveCell.FormulaR1C1 = "=MyFunction(R[variable]C[variable])" What are my options? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 using variables
Try something like ActiveCell.FormulaR1C1 = _ "=MyFunction(R" & CStr(variable) & "C" & CStr(variable) & ")" Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Wed, 21 Apr 2010 13:52:01 -0700, Cheah wrote: I want to do this but can't: ActiveCell.FormulaR1C1 = "=MyFunction(R[variable]C[variable])" What are my options? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 using variables
ActiveCell.FormulaR1C1 = "=MyFunction(R" & varR & "C" & varC & ")"
"Cheah" wrote: I want to do this but can't: ActiveCell.FormulaR1C1 = "=MyFunction(R[variable]C[variable])" What are my options? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 using variables
Don't forget your []'s:
Dim Var1 as long dim Var2 as long var1 = 21 var2 = 23 ActiveCell.FormulaR1C1 = "=MyFunction(R[" & var1 & "]C[" & var2 & "])" Cheah wrote: I want to do this but can't: ActiveCell.FormulaR1C1 = "=MyFunction(R[variable]C[variable])" What are my options? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FormulaR1C1 ? | Excel Programming | |||
What Does FormulaR1C1 Do? | Excel Programming | |||
What Does FormulaR1C1 Do? | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming |