sherrypah30
New Member
- Joined
- Apr 16, 2013
- Messages
- 3
I want to assign a SUM formula to the next empty cell in "BK" until "BM"
I don't know how many rows there will be.
example..
row 1 : =sum(bk5:bm5)
row 2 : =sum (bk6:bm6)
row 3 : =sum (bk7:bm7)
my coding :
Case Is = Worksheets("ReadyFile_Template").Cells(70, 2).Formula
For b = 5 To (intIncumbentCount + 4)
Worksheets("ReadyFile_Output").Cells(b, a).Formula = "=sum(bk5:bm5)"
Next b
i dont have idea how to passing for the next row..
using my coding only passing sum for row1 only until end of row.
I don't know how many rows there will be.
example..
row 1 : =sum(bk5:bm5)
row 2 : =sum (bk6:bm6)
row 3 : =sum (bk7:bm7)
my coding :
Case Is = Worksheets("ReadyFile_Template").Cells(70, 2).Formula
For b = 5 To (intIncumbentCount + 4)
Worksheets("ReadyFile_Output").Cells(b, a).Formula = "=sum(bk5:bm5)"
Next b
i dont have idea how to passing for the next row..
using my coding only passing sum for row1 only until end of row.