$sheet -> Range("G7:H7") -> {HorizontalAlignment} = xlHAlignCenter;            # Center text;

##</code><code>##

$sheet -> Range("F1:S1")	-> {HorizontalAlignment} = "xlCenter";
$sheet -> Range("F1:S1")	-> {VerticalAlignment} 	= "xlCenter";

##</code><code>##

    Range("A1:S1").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = True
    End With