Thread: EZ Formula Syntax Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
McManCSU[_4_] McManCSU[_4_] is offline
external usenet poster
  
Posts: 1
Default EZ Formula Syntax Question

I want to something like this:

ActiveCell.FormulaR1C1 = "=R1C&(offset+2)*RC[-4+x-2]"

(offset is some constant, and x is the var in for loop)

The VBA recorder gave me this:

ActiveCell.FormulaR1C1 = "=R1C7*RC[-4]"

What is the correct synatx to do this? Thank

--
McManCS
-----------------------------------------------------------------------
McManCSU's Profile: http://www.excelforum.com/member.php...fo&userid=2437
View this thread: http://www.excelforum.com/showthread.php?threadid=38013

Reply With QuoteReply With Quote