Thread: FormulaR1C1 using variables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cheah Cheah is offline
external usenet poster
  
Posts: 1
Default FormulaR1C1 using variables
I want to do this but can't:

ActiveCell.FormulaR1C1 = "=MyFunction(R[variable]C[variable])"

What are my options?
Reply With QuoteReply With Quote