Using Sum function in VBA

[reglarh]

This should be simple but.........

I am trying to sum a range of cells using VBA were the range of the cell is variable. The following works using absolute values:

[HTML][/HSheets("Treasurers Account").Cells(StartIncome + IncomeRowCount + 2, 5) = Application.WorksheetFunction.Sum(Range("E106:E116"))TML]

How do I replace the 106 and 116 with variables such as startrow and endrow?

[TMS]

One way:

Please Login or Register  to view this content.

[reglarh]

Thank you. I am sure that syntax was one of the many i tried with no success!

Can you also tell me why this code does not work? Nothing is cleared.

[reglarh]

Sorry!

Dim LastRow As Integer
LastRow = 100
ThisWorkbook.Sheets("Treasurers Account").Range("C" & StartIncome & ":C" & LastRow).Clear
ThisWorkbook.Sheets("Treasurers Account").Range("E" & StartIncome & ":E" & LastRow).Clear

[TMS]

I don't know.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[CheeseSandwich]

Check the value of StartIncome, you can use 'Debug.Print StartIncome' OR 'Msgbox StartIncome', make sure the value is what you expect it to be. I would guess that it is clearing an area but not the area you expected to clear.

Make sure to remove any instances of: 'On Error Resume Next' from the code to ensure you see errors when they crop up.