multiply a row by a certain number?

[Guest]

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

 

[Don Guillett]

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
(e-mail address removed)
"multiply a row by a certain number?" <multiply a row by a certain
[email protected]> wrote in message
news:[email protected]...

 

[Sandy Mann]

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
[email protected]> wrote in message
news:[email protected]...