VBA to find last row, add subtotals and then reformat

[mklindquist0815]

Is it possible to write VBA to find the last row and then sum up the values above and reformat?

[alansidman]

Simple answer. Yes. Assume your data is in column A beginning in row 1.

Please Login or Register  to view this content.

[mklindquist0815]

I have this code

Please Login or Register  to view this content.

It works great but it is populating the cells on the first worksheet with the values and not on the worksheet labeled "N".

[BellyGas]

Change worksheet.activate to worksheet.select

[alansidman]

....or change your code to the following as an alternate solution

Please Login or Register  to view this content.