Help for this page

Select Code to Download


  1. or download this
    $sheet -> Range("G7:H7") -> {HorizontalAlignment} = xlHAlignCenter;   
+         # Center text;
  2. or download this
    $sheet -> Range("F1:S1")    -> {HorizontalAlignment} = "xlCenter";
$sheet -> Range("F1:S1")    -> {VerticalAlignment}     = "xlCenter";
  3. or download this
        Range("A1:S1").Select
    With Selection
...
        .ReadingOrder = xlContext
        .MergeCells = True
    End With