Forum Discussion
Solved
How To Multiply A Range Of Cells By Same Number In Excel
Hello, i Recorded the Macro below: Sub Conversion() ' ' Conversion Macro ' ' Range("Y1").Select Selection.Copy Range("B11:AE11,B13:AE13,B15:AE15,B17:AE17,B19:AE19,B21:AE21,B23:AE23,B25...
If so, replace this argument:
Paste:=xlPasteAll
With this:
Paste:=xlValue
There is two of this in the code.
I hope that helps
Hi Sam,
Try to remove the lines that say:
Selection.NumberFormat = "0"
There are two lines of them in the macro.
Hope that helps
Thank you Haytham!
This line is to truncate the numbers. My issue is i don't want to change the color of the cell.
In the top picture below is after multiplication and removing the line you just told me about. The second picture is what it originally looked like. i Just want to multiply the numbers only without modifying the color of the cell.
If so, replace this argument:
Paste:=xlPasteAll
With this:
Paste:=xlValue
There is two of this in the code.
I hope that helps
Yes this is the solution.Thank you Haytham!