Entering a formula

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy adjacent Sheet and name from a list 42
Compare 2 excel sheets -Error Checking of entered names 1
displaying formula result 1
Macro autofills formula when a cell value is changed 4
Help with Index formula 2
Relative references in formulas 3
copying a formula to another cell 5
Vba Formula To Include Activesheet Name 3

Back
Top