Hi just,
Here's a little VBA code:
![]()
Sub AutosumC(): Dim c As Long c = Range("C" & Rows.Count).End(xlUp).row + 1 Range("C" & c) = WorksheetFunction.Sum(Range("C1:C" & c - 1)) End Sub
Hi just,
Here's a little VBA code:
![]()
Sub AutosumC(): Dim c As Long c = Range("C" & Rows.Count).End(xlUp).row + 1 Range("C" & c) = WorksheetFunction.Sum(Range("C1:C" & c - 1)) End Sub
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks