| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
increment cell reference whilst reading numeric contents
Using an Excel 2000 (9.0.2720) macro I want to sum two adjacent cells in a
row and display the result in the next cell in the row, and do this for a column of figures. I have incremented the result output OK (it displayed an error message with another formula), but cannot get the sum calculation to work. using a cell reference of the type C[i] and D[i] to increment the sum over the ranges C10:C34 + D10:D34 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
increment cell reference whilst reading numeric contents
Range("E10:E34").Formula = "=Sum(C10:D10)"
-- Regards, Tom Ogilvy "Pete Collings" <Pete wrote in message ... Using an Excel 2000 (9.0.2720) macro I want to sum two adjacent cells in a row and display the result in the next cell in the row, and do this for a column of figures. I have incremented the result output OK (it displayed an[i] error message with another formula), but cannot get the sum calculation to work. using a cell reference of the type C[i] and D to increment the sum over the ranges C10:C34 + D10:D34 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to increment a cell reference in a row | Excel Discussion (Misc queries) | |||
| Click on cell to increment contents by 1 | Excel Discussion (Misc queries) | |||
| Reading Only Numeric Value of Cell | Excel Discussion (Misc queries) | |||
| Increment cell reference | Excel Discussion (Misc queries) | |||
| reading cell contents in a macro | Excel Programming | |||
Hybrid Mode
