Thread: Put a Formula into a Cell with Index
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
alberto via OfficeKB.com alberto via OfficeKB.com is offline
external usenet poster
  
Posts: 5
Default Put a Formula into a Cell with Index
Does not works, I tried in this way,....
KK its not a colum KK can take any row number, the column is number 4.

thank you
Alberto

Tom Ogilvy wrote:
Worksheets("Sheet2").Cells(iRow, 5).Formula = "=Sheet1!$D" & kk & _
"* FacInd!$E47* FacInd!$E93"

yes, the KK is the row the Column is 4 and the Cell Formula will be in the
Sheet2:
[quoted text clipped - 18 lines]

Alberto

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1
Reply With QuoteReply With Quote