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?? |
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?? |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com