Thread: Creating a formula using the loop variable
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
  
Posts: 11,272
Default Creating a formula using the loop variable
That won't work whichever cell you are in, the other does.

--

HTH

RP

"Spector" wrote in message
...

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 - ii
& "] "
Next
End With

allan


--
Spector
------------------------------------------------------------------------
Spector's Profile:
http://www.excelforum.com/member.php...o&userid=15618
View this thread: http://www.excelforum.com/showthread...hreadid=271630



Reply With QuoteReply With Quote