from
"=R[-1]C[4]*sdFactor"
to
"=R[-1]C[4]*" & sdFactor

"Ed" wrote:

I'm having a problem entering this <<Cells(r, sdC) = Cells(r - 1, tsC) *
sdFactor as a formula in a cell. So far my efforts have produced
<<Cells(r, sdC).Formula = "=R[-1]C[4]*sdFactor" which fails apparently
because of the variable "sdFactor". This factor is obtained by preceeding
code from a different sheet.

Can someone help me, please.