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)


"alberto via OfficeKB.com" <u17340@uwe wrote in message
news:5a0f975dd170d@uwe...
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

Bob Phillips wrote:
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

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