Thread: Creating a formula using the loop variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spector[_2_] Spector[_2_] is offline
external usenet poster
  
Posts: 1
Default Creating a formula using the loop variable

Thank you so much!

Here's what I ended up actually using:
With ActiveCell
For ii = 1 To rowCnt - 1
.Offset(rowCnt, ii).FormulaR1C1 = "=R[" & ii - rowCnt & "]C[" & -1 - i
& "] "
Next
End With

alla

--
Specto
-----------------------------------------------------------------------
Spector's Profile: http://www.excelforum.com/member.php...fo&userid=1561
View this thread: http://www.excelforum.com/showthread.php?threadid=27163

Reply With QuoteReply With Quote