Copy & Paste Special Mutliply (Excel 2010)
I'm trying to write a bit of code that would simply multiply a range by -1 WITHOUT having to actually put the "-1" in the Excel worksheet in cell AA1. How can I just define the "-1" as a value or integer in the code, then "copy" the "-1" so the last two lines of code will work (in other words so the copy pastespecial multiply will work).
Thanks so much!
Range("AA1") = "-1"
Range("E2:E" & Cells(Rows.Count, 1).End(xlUp).Row).Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply