LinkBack URL
About LinkBacks
If you know last row:
Note you may not include CtrLastColumn in SUM or you will have circular reference!
.Cells(2, CtrLastColumn).Resize(LastRow - 1).FormulaR1C1 = "=Sum(RC2:RC[-1])"
If you know last row:
Note you may not include CtrLastColumn in SUM or you will have circular reference!.Cells(2, CtrLastColumn).Resize(LastRow - 1).FormulaR1C1 = "=Sum(RC2:RC[-1])"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks