Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. Sub Addtotal()
  2. Range("E18").Select
  3. ActiveCell.Formula = "Monthly Total;"
  4. Selection.Font.Bold = True
  5. Range("F18").Select
  6. ActiveCell.Formula = "=Sum($F$4:$F$17)"
  7. Selection.Font.Bold = True
  8. Columns("F").Select
  9. Selection.Columns.AutoFit
  10. Range("A1").Select
  11. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement