Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings, I've completed a massive VBA with 26 Macros. They work great as I go through them one by one, but when I use the run all macro, it will stop at one specific Macro (Left_Align). When I place an apostrophe in front of it to block it on the run all, the VBA works fine. It is like something is telling the VBA to stop running. I need to keep the sequence in order, for some macros have to run before others. It is just the one worksheet "72 Hr" I need this to work on. Thank you,
VBA Code:
Sub Left_Align()
Dim wks As Worksheet
For Each wks In Worksheets
ActiveSheet.Cells.Font.Name = "Times New Roman"
ActiveSheet.Cells.Font.Size = 12
ActiveSheet.Cells.HorizontalAlignment = xlLeft
ActiveSheet.Cells.BorderAround xlNone
ActiveSheet.Cells.VerticalAlignment = xlCenter
ActiveSheet.Cells.EntireColumn.AutoFit
End
Next
End Sub