| 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?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Range
Try this.
With Worksheets("Sheet1") If IsEmpty(.Cells(.Rows.Count, 15)) Then With .Cells(.Rows.Count, 15).End(xlUp) .Offset(2, 0).Formula = "=Sum($F$15:" & _ .Address & ")" End With "SRV....Frenzy" wrote: 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?? |
| Reply |
| 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) | |||
Linear Mode
