Thread: FormulaR1C1 using variables
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
B Lynn B B Lynn B is offline
external usenet poster
  
Posts: 131
Default 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?
Reply With QuoteReply With Quote