No, just the activesheet, for all sheets I would do that like this:
Edit - I've tested all the code I've put and it all works without error on my setup. Could you upload a workbook with the code as you are getting an error?![]()
Sub sum_C_column() Dim wSh For Each wSh In ActiveWorkbook.Sheets wSh.Range("C" & Cells(Rows.Count, 3).End(xlUp).Row) = Application.WorksheetFunction.Sum(wSh.Range("C1:C" & Cells(Rows.Count, 3).End(xlUp).Row)) Next End Sub
Bookmarks