ExcelBanter - Entering a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Entering a formula (https://www.excelbanter.com/excel-programming/410600-entering-formula.html)

Ed[_30_]

Entering a formula

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.

joel

Entering a formula

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.

All times are GMT +1. The time now is 04:44 PM.