It would have to be something like

Worksheets("Sheet2").Cells(iRow, 5).Formula = "=(Sheet1!$K4) * FacInd!$E47
* FacInd!$E93)"

I am unclear as to what cell on Sheet1 you are addressing. Is the value in
KK supposed to be the column number, and 4 the row number, vice versa, or
what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"alberto via OfficeKB.com" <u17340@uwe wrote in message
news:5a05461e1d66b@uwe...
What I want to do is :
to put a Formula into a Cell in running time

'KK is the index from the Sheet1
'FacInd other Sheet
'Sheet2 where the Cell Formula I want to put

KK = i + 2
Worksheets("Sheet2").Cells(iRow, 5).Formula = "=(Sheet1!$(KK,4) *
FacInd!$E47
* FacInd!$E93)"
but this part (Sheet1!$(KK,4) does not works
I dont know if the syntaxes is correct? Because send a error
(application-
defined or object defined error ) some thing like that.
also I have tried with a ListBox :
Worksheets("Sheet2").Cells(iRow, 5).Formula = "=(Sheet1!$(KK,4) *
FacInd!$E47
* FacInd!$E93)"

just to mention as value I can get into the cell but as Formula I can not



Please I need Help to solve this

Alberto

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