Excel Macro Class

In this post we see how to export data in Excel as PDF using VBA macros. The data can be a range or table in a worksheet, the whole workshee...

This simple macro example adds as many sheets to the workbook as cells in the selected range. The name of each sheet corresponds to the valu...

In this post we see how to unhide all sheets and cells in Excel using VBA macros. The macro loops through each worksheet in the workbook to ...

In this macro example, we compare two worksheets with data from two different versions of the same data set. Thus, we can see if there are a...

This macro example separates sheets into new workbooks, keeping the original workbook. Each new workbook takes the name of the sheet and con...

Excel offers filter options to easily narrow down the data. This macro example activates the filter option in VBA and copies the filtered da...

Excel worksheets can accommodate data across thousands of columns and more than a million rows. However, in many occasions we use only a han...

It may be useful sometimes to have a list of contents in the spreadsheet as we often do in word documents. This macro example lists all shee...

Some Excel files contain many worksheets that we may need to put in order for easier access. This macro example sorts all sheets in a workbo...