I know that adding a worksheet using VBA is done by: Sheets.Add. I know that activating a worksheet using VBA is done by: Sheets("[name]").Activate.
I was wondering if it's possible to add a worksheet and activate that newly created worksheet by using simple VBA code. If so, please let me know!