Run Macro one after the other

[DocAElstein]

Hi msiyab,
I do not really understand most of your post…

---

.... When I run the macro, ...

What macro are you talking about??

---

...When I run the macro, before one process is finished the second one start which does not give the desired result.
I want it to pause till the previous Sub is complete and then run the next line of commands.....

I don’t understand. That does not really make any sense. You are explaining very badly.

---

I think you need to try to explain everything again.

---

What is the problem in doing this?

Sub CallEmAll()
 Call UnmergeAllCells
 Call UnWrapTextAllCells
 Call PasteSpecial_ValuesOnly
 Call RowAndColumnAutoFit
 Call deleteMultipleRows
 Call DeleteColumns
End Sub

---

What is the problem in doing this?

Sub DoItAll()
'Sub UnmergeAllCells()
 ActiveSheet.Cells.UnMerge
'End Sub
'Sub UnWrapTextAllCells()
 Cells.WrapText = False
'End Sub
'Sub PasteSpecial_ValuesOnly()
'Copy A Range of Data
 Worksheets("Sheet1").Range("S2").Copy
'PasteSpecial Values Only
 Worksheets("Sheet2").Range("T2").PasteSpecial Paste:=xlPasteValues
'Clear Clipboard (removes "marching ants" around your original data set)
 Application.CutCopyMode = False
'End Sub
'Sub RowAndColumnAutoFit()
 Worksheets("Sheet1").Columns("A:BF").AutoFit
'End Sub
'Sub deleteMultipleRows()
 Rows("3:6").Delete
'End Sub
'Sub DeleteColumns()
 Worksheets("Sheet1").Range("A:C,E:F,H:J,L:S,U:X,Z:AB,AD:AH,AJ:BF").EntireColumn.Delete
'End Sub
End Sub

---

Alan