multiply a row by a certain number?

  • Thread starter multiply a row by a certain number?
  • Start date
M

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
 
D

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
[email protected]
"multiply a row by a certain number?" <multiply a row by a certain
[email protected]> wrote in message
news:[email protected]...
 
S

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]...
 
Top