MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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