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

ActiveCell.FormulaR1C1 = "=R1C" & offset+2 & "*RC" & -4+x-2

but you should be able to simply use x - 6 for the last argumen
instead of -4+x-

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

Reply With QuoteReply With Quote