Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- lastcol = Cells(14, Columns.Count).End(xlToLeft).Column
- lastrow = Cells(Rows.Count, 11).End(xlUp).Row
- Cells(lastrow, "L").Formula = "=sum(L15:L" & lastrow - 1 & ")"
- Cells((LR & "L"), Cells(LR, lastcol - 1)).Formula = "=sum(L15:L" & LR & ")"
Add Comment
Please, Sign In to add comment