View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed[_30_] Ed[_30_] is offline
external usenet poster
 
Posts: 13
Default 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.