View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

if you mean multiply each item in a column then this will work. Modify to
suit

Sub multiplyall()
For Each c In Range("c7:c10")
c.Offset(, 1) = c * 1.4
Next
End Sub
--
Don Guillett
SalesAid Software

"multiply a row by a certain number?" <multiply a row by a certain
wrote in message
...
i am having trouble with excel i want to multiply this row by 1.4 and make

it
appear next to it if anyone can help thank you