Free Excel Macros VBA | Excel VBA - TeachExcel.com - Microsoft Excel Help and Consulting

Video Tutorials

Macros

Excel Tutorials For Macros

Excel Macros Categories

Not Yet Categorized
Data Analysis Macros in Excel
- Filtering, Sorting, etc.
Queries in Excel
- Import Data from the Web, CSV Files, Text Files, etc.
Email and Microsoft Outlook Macros in Excel
Charts and Graphs Macros in Excel
Formatting Macros in Excel
Data Validation Macros in Excel
- Drop Down Menus, Lists, Input Messages, etc.

UDF - User Defined Functions in Excel
Deleting Rows and Columns in Excel
-Deleting Duplicates, Empty Rows, Empty Columns, Etc.
Worksheet Area Related Macros in Excel
- Comments, Cells, Appearance, etc.
Time Related Macros in Excel
- Run Macros at a Certain Time, Specific Intervals, etc.
Printing Macros in Excel

Data Analysis Macros in Excel

Top

Bubble Sort
- This macro will perform a bubble sort in excel. You use it simply by selecting

Sort Worksheet Tabs - Ascending or Descending Order
- This macro will sort all of the worksheets in the current workbook. It can sort

Reverse Row or Column Order in a Worksheet
- This macro reverses the order of a selected row or column in excel. It will com

Reverse Cell Contents (Mirror)
- This macro will completely reverse the contents of any cell. This means that if

Filter Data to Display the Results that Begin With Specified Text or Words in Excel - AutoFilter
- This Excel macro automatically filters a set of data based on the words or text

Filter Data to Show Only the Bottom 10 Items in Excel - AutoFilter
- This Excel macro filters a selection of data in order to display only the bottom

Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
- This free Excel macro filters a data set to display the bottom 10 percent of the

Filter Data to Show the Bottom X Number of Items in Excel - AutoFilter
- This free Excel macro filters a data set to show the bottom X number of items fr

Filter Data to Show the Bottom X Percent of the Data Set in Excel - AutoFilter
- This free Excel macro filters data to display the bottom X percent of the data s

Display Filter Arrows in a Table or Data Set in Excel - AutoFilter
- This free Excel macro allows you to apply filter settings to a data set, list, o

Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
- This free Excel macro filters data to display results that end with certain word

Filter Data in Excel - AutoFilter
- This free Excel macro filters data in Excel using the autofilter feature in an E

Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
- This free Excel macro filters data in Excel based on multiple criteria for one f

Filter Data in Excel to Display Records that Contain a Value Between Two Values - AutoFilter.
- This free Excel macro filters data to display only those records or rows that co

Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
- This Excel macro allows you to filter a data set on multiple columns and criteri

Filter Data in Excel Without the Filter "Arrow" Appearing in the Filtered Column - AutoFilter
- This Excel macro filters data in Excel without the filter "arrow" appearing in t

Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter
- This Excel macro filters data in Excel to display results that contain 1 of 2 po

Remove All Filtering From a Worksheet in Excel
- This Excel macro removes all filtering from a worksheet in Excel. This allows y

Filter Data to Show the Top 10 Items from a Data Set in Excel - AutoFilter
- This Excel macro filters data in Excel in order to display the top 10 items from

Filter Data to Show the Top 10 Percent of the Data Set in Excel - AutoFilter
- This Excel macro filters a set of data in Excel to display only the top 10 perce

Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter
- This Excel macro filters a set of data in Excel and displays only the top X perc

Filter Data to Show the Top X Number of Items in Excel - AutoFilter
- This Excel macro filters a data set to display only the top X number of items in

Sort Data that Doesn't Have Headers in Ascending Order in Excel
- Sort data that doesn't have headers in ascending order in Excel with this macro.

Sort Data With Headers in Ascending Order in Excel
- Macro that sorts data that has headers in ascending order in Excel. This macro

Sort Data that Doesn't Have Headers in Descending Order in Excel
- Sort data in Excel that doesn't have headers using a macro. This Excel macro as

Sort Data With Headers in Descending Order in Excel
- This Excel macro sorts data that has headers in descending order. This means th

Queries in Excel

Top

Basic Web Query in Excel - Import Data from the Web into Excel
- Import data from the web into Excel with this macro. This is a basic web query

Email and Microsoft Outlook Macros in Excel

Top

Email Current Workbook & or Other Attachments
- This macro will send the current workbook in an email through Microsoft Outlook.

Send Emails through Outlook using Email Addresses from Excel and text from Word
- This macro allows you to send an email to a list of recipients through excel. T

Charts and Graphs Macros in Excel

Top

Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on a

Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only dele

Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and ea

Create a Bar Chart With a Macro in Excel
- Create a bar chart in Excel with this macro. You will be able to quickly and ea

Create a Column Chart with a Macro in Excel
- This macro adds a column chart to Excel. This is an easy to use macro that allo

Formatting Macros in Excel

Top

Format Cells as an Accounting Number in Excel Number Formatting
- This free Excel macro formats a selected cell as an Accounting number. This mea

Format Cells as a Currency in Excel Number Formatting
- This free Excel macro allows you to quickly and easily format a selection of cel

Format Cells in The Long Date Number Format in Excel
- This free Excel macro formats a selection of cells in the Long Date number forma

Format Cells in The Short Date Number Format in Excel
- This free Excel macro applies the Short Date number format to a selection of cel

Format Cells as a Fraction in Excel Number Formatting
- This free Excel macro will automatically format a selected cell or many selected

Format Cells in The General (default) Format in Excel Number Formatting
- This free Excel macro formats a selected cell or range of cells to the General n

Format Cells in The Number (Numerical) Number Format in Excel
- This free Excel macro formats selected cells in the Number or Numerical number f

Format Cells as a Percentage in Excel Number Formatting
- This free Excel macro formats a selection of cells as a Percentage in Excel. Th

Format Cells as a Scientific Number in Excel Number Formatting
- This free Excel macro formats selected cells in the Scientific number format in

Format Cells as Text in Excel
- This free Excel macro formats a selection of cells as Text in Excel. This macro

Format Cells as Time in Excel
- This free Excel macro formats a selection of cells in the Time format in Excel.

Highlight Every Other Row in a Selection in Excel - Table Formatting
- This free Excel macro will highlight every other row in a selection of cells wit

Data Validation Macros in Excel

Top

Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
- Add a drop down menu or list to a cell in Excel with this free Excel macro. Thi

Add an Input Message to a Cell - Message Appears When the Cell is Selected in Excel - Data Validation Macro
- Add data validation input messages to cells in Excel with this free Excel macro.

Remove All Data Validation from a Cell in Excel
- Remove all data validation from a cell in Excel with this free Excel macro. Thi

UDF - User Defined Functions in Excel

Top

Count The Number of Words in a Cell or Range of Cells in Excel - UDF
- Count words in cells with this user defined function (UDF). This UDF allows you

Count The Number of Words in a Cell or Range of Cells in Excel - With User-Specified Delimiter / Separator - UDF
- UDF to count the number of words in a cell or range with a user-specified delimi

Calculate the Future Value (FV) of Compound Interest in Excel - UDF Macro
- This UDF (user defined function) calculates the Future Value of Compound Interes

Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter
- Extract whole words from a cell or sentence in Excel with this UDF. This allows

Generate a Non-Repeating List of Random Numbers in Excel - UDF
- Generate a series of non-repeating random numbers in Excel with this UDF (user d

Display The Actual Link / Email Address From Links in Excel - UDF
- Display the actual link or email address from links within Excel with this UDF.

Vlookup Function That Searches The Entire Workbook - UDF
- This UDF is a Vlookup function that searches the entire workbook in Excel. The

WEEKNUM UDF for Excel Versions That Don't Contain This Function - UDF
- This is a WEEKNUM UDF for Excel. This allows you to determine the number of the

Return the ISO Week Number from a Date in Excel - UDF
- Return the ISO Week Number in Excel with this UDF. This is a simple to use UDF

Return the ISO Standards Start of the Year in Excel - First Monday of the Year - UDF
- Return the date of the first Monday of any year with this UDF ISO Year function

Convert Numeric Dollar Values into Text in Excel - UDF
- Convert a numeric dollar amount into its text equivalent. This UDF (user define

Output the Worksheet Name in a Cell in Excel - UDF
- UDF to return the name of the worksheet in Excel on which this function is locat

Output the Name of the Current Excel Workbook Including Extension - UDF
- Free Excel UDF to display the name of the current Excel workbook, including the

Output the File Path to and Name of a Workbook in Excel - UDF
- Free Excel UDF (user defined function) that displays the full file path and name

Output the Name of the Current Excel Workbook Without the File Extension - UDF
- Free Excel UDF that displays the name of the Excel workbook without its extensio

Determine a Cell's Color with this UDF - Outputs as Text or the Index Number in Excel
- This free Excel UDF allows you to output the color of a cell in text format or a

Get Text from Comments in Excel Including the Author of the Comment - UDF
- Output all text from a cell comment, including comment author, with this UDF in

Get Comment Text from Cell Comments in Excel - UDF
- This free Excel UDF outputs all text from a comment in Excel. This benefit of t

Get the Number(s) Out of a Cell that Contains Both Text and Numbers in Excel - UDF
- This free Excel UDF allows you to get the numbers out of a cell that contain bot

Reverse the Contents of a Cell in Excel - UDF
- Reverse cell contents with this free Excel UDF (user defined function). This wi

Display the AutoFilter Criteria Applied to a Data Set in a Cell in Excel - UDF
- This free Excel UDF (user defined function) allows you display the filter criter

Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
- This free Excel UDF (user defined function) returns the first word from a cell i

Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
- This UDF (user defined function) extracts the last word or characters from a cel

Return the Max Number from a Range That is Within a Minimum and Maximum Target Value in Excel - UDF
- Return the highest number between two numbers that is in a range of cells with t

Determine if a Cell Contains a Function in Excel - Great for Conditional Formatting and Validation - UDF
- Determine if a cell in Excel contains a formula or function with this UDF (user

Deleting Rows and Columns in Excel

Top

Delete Empty Columns
- This macro will delete columns which are completely empty. This means that if t

Delete Duplicate Rows
- This macro will delete rows that appear twice in a list or worksheet. If two cel

Delete Entire Rows Based on Predefined Criteria (Text)
- This macro will allow you to specify certain criteria and then to delete rows ba

Delete Blank Rows in Excel
- This is a macro which will delete blank rows in excel. This version will delete

Delete Rows in Excel if Completely Empty
- This macro will delete only completely blank rows in an excel spreadsheet. It al

Worksheet Area Related Macros in Excel

Top

Delete All Comments in a Worksheet in Excel Macro
- Excel macro that will delete all of the comment contained within the active or c

Remove Comments from a Workbook in Excel - All Comments Deleted - Macro VBA
- Excel macro that will remove/delete all of the comments from an entire Excel wor

Add Comments to Cells with an Excel Macro
- Add comments to cells in Excel with this macro. This allows you to quickly and

Hide Comments in Excel Completely - Even Indicators Will not Appear
- Hide all comments in an Excel workbook. No indicators will be displayed and com

Hide Comments in Excel Partially - Comment Indicator Shows and Will Display on Hover
- Hide comments in Excel with this macro. Comment indicators will still appear in

Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
- This macro in Excel allows you to display or show a particular comment in Excel.

Display or Show all of the Comments within an Entire Excel Workbook
- This macro in Excel will display all of the comments within the entire Excel wor

Hide Specific Comments in Excel - Comments Will Still Display on Hover
- Hide specific comments in Excel with this macro. Comments are still visible on

Delete Comments in Excel - Permanently Remove Specific Comments from Excel
- Delete a comment in Excel with this macro. You can permanently remove or delete

Add Background Photos / Images to Comments in Excel
- Add background images and photos to your comments in Excel with this macro. Thi

List All Named Ranges in Excel - Displays the Name and Value for Every Named Range Within the Active Workbook in Excel
- List all of the named ranges in a workbook in Excel and the corresponding values

Time Related Macros in Excel

Top

Close a Workbook after a Time Limit is Reached
- This macro will automatically close the workbook in which it is located after th

Automatically Run a Macro so Many Seconds, Minutes, or Hours After an Excel Workbook has been Opened
- Run a macro after a certain amount of time has passed since the Excel workbook w

Automatically Run a Macro at a Certain Time - i.e. Run a Macro at 4:30PM every day
- Automatically run an Excel macro at a certain time. This allows you to not have

Printing Macros in Excel

Top

Print All Charts That are in a Worksheet
- This macro will print all of the embedded charts which are on the current active

Print all Embedded Charts in the Entire Workbook
- This macro will print every embedded chart in the active workbook. If you have a

Print Selected Worksheets in Excel
- This free excel macro will print all selected worksheets in Excel. If there are

Print The Current Worksheet in Excel
- This free Excel macro will print the current active worksheet in Excel. This me

Print Entire Workbook in Excel
- This free excel macro allows you to print the entire workbook in Excel. You can

Print Specific Pages in Excel
- This free Excel macro allows you to print a pre-specified selection of pages fro

Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is

Print Preview Screen Display for The Current or Selected Worksheets in Excel
- This free Excel macro allows you to display the print preview screen or window f

Print Preview Screen Display for The Entire Workbook in Excel
- This free Excel macro allows you to quickly and easily display the print preview

Print Preview Display for Specific Worksheets in Excel
- This free Excel macro allows you to display the print preview mode or window in

Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments t

Not Yet Categorized

Top

Automatically Highlight the Active or Selected Cell
- This macro will highlight the active cell in any excel spreadsheet with a color

Combine Multiple Workbooks into One
- This macro for Microsoft Excel allows you to combine multiple workbooks and work

Pop-Up Message Box When a Range of Cells Reaches a Certain Average
- This macro will display a message box when the numbers within a range of cells r

Pop-Up Message Box When a Cell Reaches a Certain Value or Contains Certain Text
- This macro will display a message box in excel when a cell reaches a certain val

Delete Empty or 'Broken' Named Ranges (#REF!)
- This macro will delete named ranges which refer to empty or #REF! ranges. This

Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particul

Enter Text/Characters with a Double-Click of the Mouse
- This macro allows you to enter any text or number, that you specify, in a cell o

Change Formulas to Absolute or Relative References
- This macro will change the formulas in cells to absolute or relative. It allows

Prevent Saving a Workbook under a Different File Name
- This Excel macro prevents the user from saving an excel file or workbook under a

Disables the "Save As" Feature in Excel
- This macro will disable the Save As feature in excel. This means that a user wi

Delete Multiple Named Ranges Quickly
- This macro will allow you to delete multiple named ranges very quickly. When you

Delete Hidden Worksheets
- This macro will delete all hidden worksheets within a workbook. When you run thi

Delete Hidden Rows in a Workbook
- This macro will delete hidden rows from every worksheet in an entire workbook. H

Change Text to Lowercase
- This macro will change all text within the selected cells to lowercase. It works

Highlight Cells with Text or Formulas (non-empty cells)
- This macro will highlight all cells in excel which are not empty. This means th

Highlight Cells which Contain Formulas
- This macro will highlight all of the cells in a worksheet which contain a formul

Highlight the Row and Column of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill

Highlight the Row of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill

Highlight the Column of the Selected Cell
- This macro will highlight the column of the active cell. This will fill the col

Hide Formulas in a Worksheet and Prevent Deletion
- This macro will hide all formulas within a workbook and not allow them to be del

Replace Formulas with Values (For The Entire Workbook)
- This macro will convert every formula in an entire workbook into its respective

Protect and Unprotect All Worksheets at Once
- This will allow you to protect or unprotct all worksheets in a workbook at once.

Capitalize the First Letter of Every Word in a Cell
- This macro will make the text of any selected cell in excel proper case. This me

Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With

Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do n

Open a PowerPoint Presentation from Excel
- This free macro for Microsoft Excel allows you to open any PowerPoint presentati

Open Microsoft PowerPoint from Excel
- This free macro will open the Microsoft PowerPoint program on your computer. Yo

Open Microsoft Outlook from Excel
- This free macro will open the Microsoft Outlook program on your computer. You d

Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel

Make Text to Uppercase
- This macro will change all text within the selected cells to uppercase. It works

Delete Only the Text from Cells
- This macro will delete all text from selected cells. This will not delete any o

Remove (Delete) Hyperlinks from Worksheets
- This macro will remove all hyperlinks from the active worksheet. It will delete

Create a 12 Month Calendar With The Current Day Highlighted in Excel
- Create a 12 month formatted calendar on a new tab in Excel with the current day

Delete a VBA Module From Excel
- Delete a VBA macro module from Excel with this macro. This macro allows you to

Random Tutorials

Add Y-Error Bars to a Graph or Chart in Excel
(Easy)

Adjusting Multiple Rows & Columns Simultaneously
(Easy)

Create a Two-Way Lookup in Excel
(Intermediate)

Remove #N/A Error Result from Empty VLOOKUP() Formulas
(Intermediate)

Lookups With MATCH() and INDEX() Functions
(Intermediate)

IF Statement Introduction & Using Nested IF's
(Easy)