Worksheet Operations with Excel VBA Archives

Worksheet Operations with Excel VBA

How to Rename a Sheet with Excel VBA (11 Different Criteria)

Nighat Hossain February 1, 2026

In some cases, when working with an Excel dataset, we need to rename one or more sheets in our workbook to keep them organized or to make the sheet names more meaningful for reports or analysis. ...

Excel VBA

How to Save Worksheet as New File with Excel VBA

Nighat Hossain February 7, 2026

featured image - save worksheet as new file in excel vba

When working with a large Excel worksheet, you often need to share or save individual sheets. Obviously, it will be very time-consuming and repetitive to save each worksheet manually. Excel VBA makes ...