Advertisement
Guest User

Untitled

a guest
Apr 27th, 2017
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. Sub NoFormulas()
  2. Application.ScreenUpdating = False
  3. For Each iList In ActiveWorkbook.Worksheets
  4. iList.Cells.Copy
  5. iList.Cells.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
  6. :=False, Transpose:=False
  7. Application.CutCopyMode = False
  8. Next
  9. Application.ScreenUpdating = True
  10.  
  11. End Sub
  12.  
  13. Sub Reset_Styles()
  14. '
  15. For Each objStyle In ActiveWorkbook.Styles
  16. On Error Resume Next
  17. If Not objStyle.BuiltIn Then objStyle.Delete
  18. On Error GoTo 0
  19. Next objStyle
  20. '
  21. Set wbMy = ActiveWorkbook
  22. Set wbNew = Workbooks.Add
  23. wbMy.Styles.Merge wbNew
  24. wbNew.Close savechanges:=False
  25. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement