pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
Hi!
Below is my current code.
If I want the code to run in different sheet say, in sheet1, sheet2, sheet3 one after another
how do I code it.
Thanks for helping.
Pedie!
Below is my current code.
If I want the code to run in different sheet say, in sheet1, sheet2, sheet3 one after another
how do I code it.
Thanks for helping.
Pedie!

Code:
Sub formatcells()
Cells.Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
Range("A1").Select
End Sub