Question: how to insert new sheet in excel using vba?
Answer: Activate Visual Basic Editor by pressing Alt+F11. Right-click the project/workbook name in the project window. Choose Insert→Module. Type or paste the code in the newly created module.