pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
This is my current code:
I want this code to run in different 3 sheets, namely; "data", "Update","Tracer"
I have another sheets and I do not want the macro to run there.
THanks alot!
Code:
Sub Left_format()
Dim i As Integer
For i = 1 To 4
With Sheets(i)
With .Cells
.HorizontalAlignment = xlLeft
End With
End With
Next i
End Sub
I have another sheets and I do not want the macro to run there.
THanks alot!