Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.

In this article we will show you how to add a sheet to an Excel workbook using VBA. There are 2 different methods detailed below in order to do this.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...

How to Link Sheets Using Visual Basic in Excel. Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use ...