Excel macro - Find very last row on sheet, then add a calculation to column L
Posted on 2006-04-05
I have an Excel sheet that the number of rows are constantly changing.
I currently have a macro that adds 10 new rows to the bottom of the sheet and highlights the ten new rows (thank you dave4dl):
Dim curcell As Range
Dim highlightRange As Range
Set curcell = Range("a1").SpecialCells(xlLastCell)
Set highlightRange = Range(Cells(curcell.Row +1,1), Cells(curcell.Row +10,12))
highlightRange.Interior.Color = RGB(255,255,0)
I am now looking for a macro that will add a calculation to column L, rows 5 - ??. The calculation is the sum of columns G and I (=SUM(G#:I#) for each row. This calculation is to be added to column L, rows 5 - ??(to the end of the 10 new highlighted rows).