Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I am trying to write a macro to increment/decrement the values in a range of selected cells (e.g. R3C3:R8C10). I got as far as returning the address of the selected cells ("R3C3:R8C10") using: ActiveWindow.RangeSelection.address(True,True,xlR1 C1) Now how do I use these address "corners" to cycle through the cells? Range() and Cell() seem to require a different format. Or, is there a simpler way to add/subtract/multiply a selected range of cells by another value? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell math to decrement/increment a cell | Excel Worksheet Functions | |||
Macro to take selected cells times a selected cell | Excel Programming | |||
How do I increment or decrement values in a column? | New Users to Excel | |||
Provide increment and decrement buttons on toolbar line | Excel Programming | |||
Spin Button to increment or decrement the date in cell A1 | Excel Programming |