Showing posts with label Worksheet. Show all posts
Showing posts with label Worksheet. Show all posts

Saturday, November 16, 2024

Add Sheets From Selection Excel VBA Macro

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 value in the cell. It is a quick way to format a workbook from a template of sheets to be added.


Saturday, November 12, 2022

Unhide All Sheets And Cells Excel VBA Macro

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 make any hidden or very hidden worksheet visible. At the same time and while in the loop, it also unhides all rows and columns, which subsequently unhides all the cells in that worksheet.


Saturday, December 11, 2021

Compare Two Worksheets Excel VBA Macro

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 any changes in version 2 compared to version 1. The changes are highlighted in yellow.

Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Friday, September 24, 2021

Separate Sheets Into Workbooks Excel VBA Macro

This macro example separates sheets into new workbooks, keeping the original workbook. Each new workbook takes the name of the sheet and contains one single sheet with its original contents.

Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Tuesday, July 21, 2020

Copy Filtered Data To New Sheets Excel VBA Macro

Excel offers filter options to easily narrow down the data. This macro example activates the filter option in VBA and copies the filtered data for each unique entry to separate sheets.

Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Remove Unused Rows And Columns Excel VBA Macro

Excel worksheets can accommodate data across thousands of columns and more than a million rows. However, in many occasions we use only a handful and may want to just present our data set and get rid of all the useless rows and columns. This example removes all unused rows and columns in a worksheet.

Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Monday, July 6, 2020

List And Link All Sheets Excel VBA Macro

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 sheets in a workbook and adds a hyperlink to quickly access each of them.

Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Tuesday, June 30, 2020

Sort Sheets Alphabetically Excel VBA Macro

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 workbook alphabetically from A to Z. Use the code below to sort sheets alphabetically with Excel VBA.
 
Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Popular Posts