Dear Experts!
I have recorded a macro for some cleaning/formatting purpose which will rearrange my excel sheet. I need to run this macro on every visible sheets and speedup the process.
Can anyone help me in this regards.
Sub RunMetoClean()
Application.DisplayAlerts = False
Application.EnableEvents = False
Application.ScreenUpdating = False
Range("F:H,J:L,N:P,R:T").Select
Range("R1").Activate
Range("F:H,J:L,N:P,R:T,V:X,Z:AB,AD:AF,AH:AJ").Select
Range("AH1").Activate
Range("F:H,J:L,N:P,R:T,V:X,Z:AB,AD:AF,AH:AJ,AL:AN,AP:AR,AT:AV,AX:AZ,BB:BD"). _
Select
Range("BB1").Activate
Range( _
"F:H,J:L,N:P,R:T,V:X,Z:AB,AD:AF,AH:AJ,AL:AN,AP:AR,AT:AV,AX:AZ,BB:BD,BH:BS"). _
Select
Range("BH1").Activate
Selection.Delete Shift:=xlToLeft
Range("U23").Select
Columns("A:A").Select
Selection.Delete Shift:=xlToLeft
Range("E12").Select
Columns("B:B").Select
' Application.Run "modPaste.Copy"
Selection.Copy
Columns("C:C").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
With Selection.Font
.Color = -16776961
.TintAndShade = 0
End With
Columns("B:B").Select
With Selection.Font
.ThemeColor = xlThemeColorDark1
.TintAndShade = 0
End With
Range("E12").Select
Rows("1:11").Select
Range("A11").Activate
Selection.Delete Shift:=xlUp
Rows("1:4").Select
Selection.Insert Shift:=xlDown
Range("C8").Select
ActiveWindow.SmallScroll Down:=-9
Application.DisplayAlerts = True
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub
Bookmarks