Guest User

Untitled

a guest
Oct 16th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. Do While v <= n
  2. If Cells(v, 2) <> "" And Cells(v, 2) <> "Call Center" And Cells(v, 2) <> drzava Then Rows(v).Delete Else v = v + 1
  3. Loop
  4.  
  5. Sub SaveALLCountries()
  6.  
  7. Dim drzava$, nov As Workbook, ime$, v%, n%, a As Double
  8.  
  9. Application.ScreenUpdating = False
  10.  
  11. For i = 1 To 38
  12. ThisWorkbook.Activate
  13. Application.StatusBar = i
  14. ThisWorkbook.Sheets("Results by CC").Range("CB14") = i
  15. drzava = ThisWorkbook.Sheets("Results by CC").Range("CD12")
  16. Workbooks.Add
  17. Set nov = ActiveWorkbook
  18. ThisWorkbook.Sheets("Results by CC").Copy Before:=nov.Sheets(1)
  19. ActiveSheet.Shapes.Range(Array("List Box 2")).Delete
  20. Cells.Select
  21. Selection.Copy
  22. Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
  23. :=False, Transpose:=False
  24. Range("A1").Select
  25. ThisWorkbook.Sheets("2018 Q2 Open answers").Copy Before:=nov.Sheets(2)
  26. Application.DisplayAlerts = False
  27. nov.Sheets(3).Delete
  28. Sheets("2018 Q2 Open answers").Select
  29. ActiveSheet.Outline.ShowLevels RowLevels:=2
  30. n = Application.WorksheetFunction.CountA(Sheets("2018 Q2 Open answers").Columns(2)) + 10
  31. v = 1
  32. Do While v <= n
  33. If Cells(v, 2) <> "" And Cells(v, 2) <> "Call Center" And Cells(v, 2) <> drzava Then Rows(v).Delete Else v = v + 1
  34. Loop
  35. ActiveSheet.Outline.ShowLevels RowLevels:=1
  36. Range("A1").Select
  37. ActiveWorkbook.Names("CallCenterSelect").Delete
  38. Sheets("Results by CC").Select
  39. ime = ThisWorkbook.Path & "" & Sheets("Results by CC").Range("CD14").Value & ".xlsx"
  40. nov.SaveAs ime, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
  41. nov.Close
  42.  
  43. Next i
  44.  
  45. Application.ScreenUpdating = True
  46. Application.StatusBar = False
Add Comment
Please, Sign In to add comment