Insert Formulas
Posted by Scott Staples on July 25, 2000 12:43 PM
I need to insert formulas in cells that will multiply the value in the A column and the value in the E column. I think I have figured out how but there is something wrong with the syntax. The code is pasted below, any help is appreciated.
cll = 10
Do
cll = cll + 1
range("I" & cll).formula = ("=A" & cll "* E" & cll)
Loop Until cll = 54
Posted by Ivan Moala on July 26, 0100 1:24 AM
Try
cll = 10
Do
cll = cll + 1
Range("I" & cll).Formula = "=A" & cll & "* E" & cll
Loop Until cll = 54
Ivan
Posted by Ada on July 25, 0100 6:13 PM
Scott
Range("I" & cll).Formula = "=A" & cll & "*E" & cll
Ada
