Worksheet Operations

3 lessons in order

Learn how to save a worksheet as a new file in Excel VBA, whether saving one sheet, all sheets separately, or only those with specific text.

Learn how to rename a sheet with Excel VBA using indexes, cell values, codenames, conditions, files, and naming techniques fast.

Learn how to add a sheet with a specific name in Excel VBA, rename instantly, and insert it at a chosen location easily.