Vba Add Worksheet With Name. Activate the visual basic editor by pressing alt + f11. If you still want to do this the old.
Note that with add the new sheet always becomes the active sheet. Syntax you can create and name a worksheet using the sheets.add and worksheets.add methods. The following steps teach you how to put vba code into a standard module: