| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Most efficient code to "flip" a range of values + vs -
2003/2007
Range("A1").Value = Range("A1").Value * -1 will quickly flip "A1" 9999 to -9999 Let's assume that Set myRange = Range("A1:A3") How does one "flip" the values in myRange? As myRange.Value = myRange.Value * -1 does not work. TIA EagleOne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup returning the sum of multiple values from one "code" | Excel Worksheet Functions | |||
| Reverse a "row" of numbers (flip flop them)? | New Users to Excel | |||
| Setting values for "TRUE","FALSE" and "#REF!" | Excel Programming | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Threaded Mode
