Guest User


a guest
Oct 24th, 2016
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub Splitbook()
  2. MyPath = ThisWorkbook.Path
  3. For Each sht In ThisWorkbook.Sheets
  4. sht.Copy
  5. ActiveSheet.Cells.Copy
  6. ActiveSheet.Cells.PasteSpecial Paste:=xlPasteValues
  7. ActiveSheet.Cells.PasteSpecial Paste:=xlPasteFormats
  8. ActiveWorkbook.SaveAs _
  9. Filename:=MyPath & “\” & sht.Name & “.xls”
  10. ActiveWorkbook.Close savechanges:=False
  11. Next sht
  12. End Sub
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add to your ad blocker whitelist or disable your adblocking software.