The select method of a worksheet object selects the worksheet and optionally adds it to the currently selected set of worksheets.
A worksheet is added if the optional parameter is set to false.
If multiple worksheets are selected, activeCell refers to the respective cell in all selected worksheets.
sub main()
dim ws1, ws2, ws3 as worksheet
set ws1 = worksheets.add
set ws2 = worksheets.add
set ws3 = worksheets.add
ws1.name = "WS one"
ws2.name = "WS two"
ws3.name = "WS three"
ws1.select
ws3.select false ' Add to selection of worksheets
cells(2,3).select
with activeCell
.value = "This text appears in worksheets one and three"
.font.bold = true
.font.size = 20
end with
end sub