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 ' }
range
Index