Adding and activating a worksheet VBA

Viewed 17

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!

0 Answers
Related