multiply a row by a certain number?
 

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

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

Copy & paste the data into the next column then, in an empty cell anywhere
in the sheet, enter 1.4 and copy that cell. Highlight the newly pasted
column and then right click and select Paste Special Multiply


HTH

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"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