| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Range
hi all,
please help me ActiveWorkbook.ActiveSheet.Range(Cells(4, 7), Cells((mData + 3), 7)).Formula = "=SUM()" and ActiveWorkbook.ActiveSheet.Range("F15").Formula = "=SUM(range.cells(4,7),cells((mData+3),7))" both are not working all i want to do is add the numbers in the column but the numbers can be more and less that is why i have applied range.cells can anyone help any ideas?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate within a range? | Excel Worksheet Functions | |||
| How can I calculate the Moving-Range without returning negatives | Excel Discussion (Misc queries) | |||
| Calculate Date range | Excel Worksheet Functions | |||
| Calculate max value in specific range | Excel Discussion (Misc queries) | |||
| How to Calculate a sum between a rolling data range. | Excel Discussion (Misc queries) | |||
Threaded Mode
