Formatting Excel Worksheet cells from VBA code

[Guest]

After coding in your range of cells the following will
format that range.....adjust for whatever formating you
require....


Selection.NumberFormat = "@"
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = False
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.MergeCells = False
End With