| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert SUM function for range
Dear All,
I have a variable range of data in a column. Exactly at the bottom of this column I need to insert a SUM function for the numbers above (not just calculate the totals). I tried ActiveSheet.Range("a6").End(xlDown).Offset(1, 0).Formula = "=SUM(a2:(Range("a6").End(xlDown))" but it's not working Please advise! Thanks. Denis Petrov |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO i INSERT A RANGE OF SERIAL DATES IN THE WORKDAY FUNCTION | Excel Worksheet Functions | |||
| Insert range of cells with a function | Excel Worksheet Functions | |||
| How do I insert a calculated cell range into an excel function | Excel Worksheet Functions | |||
| How to insert from name range into a paragraph? | Excel Worksheet Functions | |||
| Insert...Name Range | Excel Discussion (Misc queries) | |||
Threaded Mode
