Search notes:

Excel Object Model: Range.Merge

option explicit

sub main() ' {

    with activeSheet.cells(2,2)

        .resize(1,3).merge

        .value               ="hello world"
        .horizontalAlignment = xlCenter
        .font.bold           = true
        .interior.themeColor = xlThemeColorAccent6
    end with

end sub ' }

See also

Home -> Alignment -> Merge & Center -> Merge Cells
The range object

Index