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.