Put a Formula into a Cell with Index

[alberto via OfficeKB.com]

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

 

[Bob Phillips]

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]

yes, the KK is the row the Column is 4 and the Cell Formula will be in the
Sheet2:
but KK is selected in running time by ListBox index


Thank you Bob

Alberto

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?

What I want to do is :
to put a Formula into a Cell in running time

[quoted text clipped - 18 lines]

Alberto

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

yes, the KK is the row the Column is 4 and the Cell Formula will be in the
Sheet2:
but KK is selected in running time by ListBox index


Thank you Bob

Alberto

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?

What I want to do is :
to put a Formula into a Cell in running time

[quoted text clipped - 18 lines]

Alberto

 

[alberto via OfficeKB.com]

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

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]

 

[Bob Phillips]

That is what Tom gave you, he hardcoded a column of 'D'.

--

HTH

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

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

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

 

[alberto via OfficeKB.com]

I am sorry English is not my language I do not understand the term
<<hardcoded a colums of 'D'>>

could you please explain me

thank you
Alberto

That is what Tom gave you, he hardcoded a column of 'D'.

Does not works, I tried in this way,....
KK its not a colum KK can take any row number, the column is number 4.

[quoted text clipped - 10 lines]

 

[Bob Phillips]

Tom gave you

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

In this the column, D, is explicitly stated, it is not dependent on any
variable, whereas the row is a variable KK. So if KK is 4, this is
equivalent to putting the formula

=Sheet1!$D4* FacInd!$E47* FacInd!$E93

in that cell. This appears to be what you asked for.


--

HTH

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

I am sorry English is not my language I do not understand the term
<<hardcoded a colums of 'D'>>

could you please explain me

thank you
Alberto

That is what Tom gave you, he hardcoded a column of 'D'.

Does not works, I tried in this way,....
KK its not a colum KK can take any row number, the column is number 4.

[quoted text clipped - 10 lines]

Alberto

 

[alberto via OfficeKB.com]

Thnak you all of you Tom and Bob you have pretty good understanding of Excel
you help me too much!
I do appreciate all your help, could suggest me any refference where to study
or where to see that kind of knowledge,
once again , thank you very much

Alberto

Tom gave you

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

In this the column, D, is explicitly stated, it is not dependent on any
variable, whereas the row is a variable KK. So if KK is 4, this is
equivalent to putting the formula

=Sheet1!$D4* FacInd!$E47* FacInd!$E93

in that cell. This appears to be what you asked for.

I am sorry English is not my language I do not understand the term
<<hardcoded a colums of 'D'>>

[quoted text clipped - 11 lines]