Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is what I am trying to do:
1. select a range of cells, which may or may not be continuous 2. change the row number reference in each of the cell's formulas by adding or subtracting to an integer to each reference to a row number i.e. if one of the cells in the range had the formula =H325+H320+H308+H303 I would like to be able to add or subtract an integer to it to get (in the instance the integer was +2) =H327+H322+H310+H305 This operation would need to repeat for each cell in the selected range. I read a few similar posts to try and get this to work, but didn't have any success. A solution would be greatly appreciated ! Thanks, Joshua |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to increment a cell reference in a row | Excel Discussion (Misc queries) | |||
How do I get a worksheet reference to increment when copied | Excel Worksheet Functions | |||
Increment cell reference | Excel Discussion (Misc queries) | |||
Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions |