Setting range to last row in a table

Hi everyone,

I'm a complete novice at excel and vba. If you see the attached worksheet, my goal was to have a code that would fill each blank cell in columns A and B with the sum of the cells before it, until it reached another blank cell. I searched online and have found a code that works, see below, however it is a defined range. I will be inputting new data daily and therefore need it to automatically adjust the range to the last row in the table. I've searched the internet for a couple of weeks now trying to find a solution that works to no avail. My current code is:

Please Login or Register  to view this content.

Thank you for your quick reply.

I've copied it over into my spreadsheet, and changed this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

as that is where the columns are on my full sheet. When I run the code, it says error "9", Subscript out of range and highlights this column

Please Login or Register  to view this content.

.

Is there anything else I should change?

Thank you!

Worked an absolute treat!!! Thank you so much, the amount of time I've spent trying to work it out myself is unbelievable haha.

Thanks again!

Please Login or Register  to view this content.