? 国 title macro 2
- ? 国 title description macro 1 2 ...
- ? 国 title description macro 1 2 ...
Bubble Sort
- This macro will perform a bubble sort in excel. You use it simply by selecting one column to sort and then running ...
- This macro will perform a bubble sort in excel. You use it simply by selecting one column to sort and then running ...
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, or range of data in Excel. This will ...
- This free Excel macro allows you to apply filter settings to a data set, list, or range of data in Excel. This will ...
Excel Macro that Searches Entire Workbook and Returns All Matches
- This is the ultimate Lookup Macro for Excel. It will search every worksheet in the workbook and return all of the m ...
- This is the ultimate Lookup Macro for Excel. It will search every worksheet in the workbook and return all of the m ...
Filter Data in Excel - AutoFilter
- This free Excel macro filters data in Excel using the autofilter feature in an Excel macro. To use this macro all y ...
- This free Excel macro filters data in Excel using the autofilter feature in an Excel macro. To use this macro all y ...
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 contain a value between two values. F ...
- This free Excel macro filters data to display only those records or rows that contain a value between two values. F ...
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 possible values. This macro uses the ...
- This Excel macro filters data in Excel to display results that contain 1 of 2 possible values. This macro uses the ...
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 percent of that data. This means the hi ...
- This Excel macro filters a set of data in Excel and displays only the top X percent of that data. This means the hi ...
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 field in the data set. This macro us ...
- This free Excel macro filters data in Excel based on multiple criteria for one field in the data set. This macro us ...
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 the column that is being filtered. T ...
- This Excel macro filters data in Excel without the filter "arrow" appearing in the column that is being filtered. T ...
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 criteria at once. This means that you can ...
- This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can ...
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 that are contained in the beginning ...
- This Excel macro automatically filters a set of data based on the words or text that are contained in the beginning ...
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 10 items in the list or data set. ...
- This Excel macro filters a selection of data in order to display only the bottom 10 items in the list or data set. ...
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 data set in Excel. This is a great ...
- This free Excel macro filters a data set to display the bottom 10 percent of the data set in Excel. This is a great ...
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 from that data set. This macro is rea ...
- This free Excel macro filters a data set to show the bottom X number of items from that data set. This macro is rea ...
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 set in Excel. This is a great macro ...
- This free Excel macro filters data to display the bottom X percent of the data set in Excel. This is a great macro ...
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 the data set. The macro uses the a ...
- This Excel macro filters data in Excel in order to display the top 10 items from the data set. The macro uses the a ...
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 percent of that data set. This means tha ...
- This Excel macro filters a set of data in Excel to display only the top 10 percent of that data set. This means tha ...
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 that data set in Excel. This means ...
- This Excel macro filters a data set to display only the top X number of items in that data set in Excel. This means ...
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 words, text, or characters. This is a v ...
- This free Excel macro filters data to display results that end with certain words, text, or characters. This is a v ...
Remove All Filtering From a Worksheet in Excel
- This Excel macro removes all filtering from a worksheet in Excel. This allows you to completely remove any filter n ...
- This Excel macro removes all filtering from a worksheet in Excel. This allows you to completely remove any filter n ...
Reverse Cell Contents (Mirror)
- This macro will completely reverse the contents of any cell. This means that if you have a cell which reads "My Tex ...
- This macro will completely reverse the contents of any cell. This means that if you have a cell which reads "My Tex ...
Reverse Row or Column Order in a Worksheet
- This macro reverses the order of a selected row or column in excel. It will completely reverse the data. This is di ...
- This macro reverses the order of a selected row or column in excel. It will completely reverse the data. This is di ...
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. This is a simple sort macro that a ...
- Sort data that doesn't have headers in ascending order in Excel with this macro. This is a simple sort macro that a ...
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 assumes that your data set does not ha ...
- Sort data in Excel that doesn't have headers using a macro. This Excel macro assumes that your data set does not ha ...
Sort Data With Headers in Ascending Order in Excel
- Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on ...
- Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on ...
Sort Data With Headers in Descending Order in Excel
- This Excel macro sorts data that has headers in descending order. This means that data is sorted Z to A and 10 to 1 ...
- This Excel macro sorts data that has headers in descending order. This means that data is sorted Z to A and 10 to 1 ...
Sort Worksheet Tabs - Ascending or Descending Order
- This macro will sort all of the worksheets in the current workbook. It can sort in ascending or descending order. T ...
- This macro will sort all of the worksheets in the current workbook. It can sort in ascending or descending order. T ...
test 1
- Code: Sub Convert_Html_Entities() '''''''''''''' TeachExcel.com '''''''''''''' 'Convert HTML Entities into read ...
- Code: Sub Convert_Html_Entities() '''''''''''''' TeachExcel.com '''''''''''''' 'Convert HTML Entities into read ...
test 2 ? 国
- Sub Convert_Html_Entities() '''''''''''''' TeachExcel.com '''''''''''''' 'Convert HTML Entities into readable t ...
- Sub Convert_Html_Entities() '''''''''''''' TeachExcel.com '''''''''''''' 'Convert HTML Entities into readable t ...
Vlookup Macro to Return All Matching Results and Stack them with Previous Results
- This is very similar to the other Vlookup type Macro in that it returns all of the results that match a particular ...
- This is very similar to the other Vlookup type Macro in that it returns all of the results that match a particular ...
Vlookup Macro to Return All Matching Results from a Sheet in Excel
- This Excel Macro works like a better Vlookup function because it returns ALL of the matching results. Run the macro ...
- This Excel Macro works like a better Vlookup function because it returns ALL of the matching results. Run the macro ...
Automatically Copy New Data to Another Worksheet
- This macro allows you to quickly and easily copy all new data from one worksheet to another; it also allows you to ...
- This macro allows you to quickly and easily copy all new data from one worksheet to another; it also allows you to ...
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 macro that will import data from any ...
- Import data from the web into Excel with this macro. This is a basic web query macro that will import data from any ...
Combine Multiple Workbooks into One
- This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and wo ...
- This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and wo ...
Combine Worksheets from Multiple Workbooks into One
- Excel macro that allows you to select multiple workbooks and have all of their worksheets automatically combined in ...
- Excel macro that allows you to select multiple workbooks and have all of their worksheets automatically combined in ...
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be ...
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be ...
List All Files from a Directory into Excel
- Get a list of all files from a directory into an Excel worksheet. This allows you to navigate to anywhere on your c ...
- Get a list of all files from a directory into an Excel worksheet. This allows you to navigate to anywhere on your c ...
Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to ...
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to ...
Save the Current Worksheet as a New File in the Current Folder
- This Excel Macro saves the currently visible worksheet into the SAME folder as the current file. It is different fr ...
- This Excel Macro saves the currently visible worksheet into the SAME folder as the current file. It is different fr ...
Email Current Workbook & or Other Attachments
- Send Emails from Excel Course This macro will send the current workbook in an email through Microsoft Outlook. The ...
- Send Emails from Excel Course This macro will send the current workbook in an email through Microsoft Outlook. The ...
Email List of People from Excel Using a Macro
- Send Emails from Excel Course Send emails to everyone in a list in Excel using a macro. The message for the email c ...
- Send Emails from Excel Course Send emails to everyone in a list in Excel using a macro. The message for the email c ...
Send Emails through Outlook using Email Addresses from Excel and text from Word
- Send Emails from Excel Course This macro allows you to send an email to a list of recipients through excel. The ema ...
- Send Emails from Excel Course This macro allows you to send an email to a list of recipients through excel. The ema ...
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 easily turn any range of numbers and d ...
- Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and d ...
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 allows you to quickly chart and graph a ...
- This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a ...
Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs f ...
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs f ...
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 delete the charts and graphs that are in ...
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in ...
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get t ...
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get t ...
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 means that the first letter of any wo ...
- This macro will make the text of any selected cell in excel proper case. This means that the first letter of any wo ...
Create an Index / Table of Contents worksheet
- To create an Index / Table of Contents worksheet to a workbook: 1) Add a new worksheet and name it "Index" 2) Open ...
- To create an Index / Table of Contents worksheet to a workbook: 1) Add a new worksheet and name it "Index" 2) Open ...
Format Cells as a Currency in Excel Number Formatting
- This free Excel macro allows you to quickly and easily format a selection of cells in the Currency number format in ...
- This free Excel macro allows you to quickly and easily format a selection of cells in the Currency number format in ...
Format Cells as a Fraction in Excel Number Formatting
- This free Excel macro will automatically format a selected cell or many selected cells in the Fraction number forma ...
- This free Excel macro will automatically format a selected cell or many selected cells in the Fraction number forma ...
Format Cells as a Percentage in Excel Number Formatting
- This free Excel macro formats a selection of cells as a Percentage in Excel. This simply changes a cell's number fo ...
- This free Excel macro formats a selection of cells as a Percentage in Excel. This simply changes a cell's number fo ...
Format Cells as a Scientific Number in Excel Number Formatting
- This free Excel macro formats selected cells in the Scientific number format in Excel. This means the cell will be ...
- This free Excel macro formats selected cells in the Scientific number format in Excel. This means the cell will be ...
Format Cells as an Accounting Number in Excel Number Formatting
- This free Excel macro formats a selected cell as an Accounting number. This means that the accounting number format ...
- This free Excel macro formats a selected cell as an Accounting number. This means that the accounting number format ...
Format Cells as Text in Excel
- This free Excel macro formats a selection of cells as Text in Excel. This macro applies the Text number format to c ...
- This free Excel macro formats a selection of cells as Text in Excel. This macro applies the Text number format to c ...
Format Cells as Time in Excel
- This free Excel macro formats a selection of cells in the Time format in Excel. This Time number format means that ...
- This free Excel macro formats a selection of cells in the Time format in Excel. This Time number format means that ...
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 number format in Excel. This is the ...
- This free Excel macro formats a selected cell or range of cells to the General number format in Excel. This is the ...
Format Cells in The Long Date Number Format in Excel
- This free Excel macro formats a selection of cells in the Long Date number format in Excel. The Long Date number fo ...
- This free Excel macro formats a selection of cells in the Long Date number format in Excel. The Long Date number fo ...
Format Cells in The Number (Numerical) Number Format in Excel
- This free Excel macro formats selected cells in the Number or Numerical number format in Excel. This means that the ...
- This free Excel macro formats selected cells in the Number or Numerical number format in Excel. This means that the ...
Format Cells in The Short Date Number Format in Excel
- This free Excel macro applies the Short Date number format to a selection of cells in Excel. This number format dis ...
- This free Excel macro applies the Short Date number format to a selection of cells in Excel. This number format dis ...
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 with a color that is specified within ...
- This free Excel macro will highlight every other row in a selection of cells with a color that is specified within ...
Make Text Uppercase
- This macro will change all text within the selected cells to uppercase. It works only on selected cells within Micr ...
- This macro will change all text within the selected cells to uppercase. It works only on selected cells within Micr ...
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. This is a great little macro that allow ...
- Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a great little macro that allow ...
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. These messages appear when a speci ...
- Add data validation input messages to cells in Excel with this free Excel macro. These messages appear when a speci ...
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 value or contains certain text. This m ...
- This macro will display a message box in excel when a cell reaches a certain value or contains certain text. This m ...
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 reaches an average of 5. The current ...
- This macro will display a message box when the numbers within a range of cells reaches an average of 5. The current ...
Remove All Data Validation from a Cell in Excel
- Remove all data validation from a cell in Excel with this free Excel macro. This is a great macro to use when you n ...
- Remove all data validation from a cell in Excel with this free Excel macro. This is a great macro to use when you n ...
Calculate the Future Value (FV) of Compound Interest in Excel - UDF Macro
- This UDF (user defined function) calculates the Future Value of Compound Interest in Excel. The mathematical formu ...
- This UDF (user defined function) calculates the Future Value of Compound Interest in Excel. The mathematical formu ...
Convert Numeric Dollar Values into Text in Excel - UDF
- Convert a numeric dollar amount into its text equivalent. This UDF (user defined function) for Excel will change or ...
- Convert a numeric dollar amount into its text equivalent. This UDF (user defined function) for Excel will change or ...
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 to count the number of words that a ...
- Count words in cells with this user defined function (UDF). This UDF allows you to count the number of words that a ...
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 delimiter. This means that you can tell ...
- UDF to count the number of words in a cell or range with a user-specified delimiter. This means that you can tell ...
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 as that color's index number. Also n ...
- This free Excel UDF allows you to output the color of a cell in text format or as that color's index number. Also n ...
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 defined function). This function re ...
- Determine if a cell in Excel contains a formula or function with this UDF (user defined function). This function re ...
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. This user defined function pulls th ...
- Display the actual link or email address from links within Excel with this UDF. This user defined function pulls th ...
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 criteria that has been applied to a data ...
- This free Excel UDF (user defined function) allows you display the filter criteria that has been applied to a data ...
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 you to specify which word from a ce ...
- Extract whole words from a cell or sentence in Excel with this UDF. This allows you to specify which word from a ce ...
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 in Excel. This extracts the first w ...
- This free Excel UDF (user defined function) returns the first word from a cell in Excel. This extracts the first w ...
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 cell in Excel. This is done by finding ...
- This UDF (user defined function) extracts the last word or characters from a cell in Excel. This is done by finding ...
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 defined function). This is a great f ...
- Generate a series of non-repeating random numbers in Excel with this UDF (user defined function). This is a great f ...
Get Comment Text from Cell Comments in Excel - UDF
- This free Excel UDF outputs all text from a comment in Excel. This benefit of this UDF is that it doesn't display t ...
- This free Excel UDF outputs all text from a comment in Excel. This benefit of this UDF is that it doesn't display t ...
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 Excel. This UDF (user defined funct ...
- Output all text from a cell comment, including comment author, with this UDF in Excel. This UDF (user defined funct ...
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 both text and numbers. This is a grea ...
- This free Excel UDF allows you to get the numbers out of a cell that contain both text and numbers. This is a grea ...
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 of an Excel workbook. This functio ...
- Free Excel UDF (user defined function) that displays the full file path and name of an Excel workbook. This functio ...
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 workbook extension. This function h ...
- Free Excel UDF to display the name of the current Excel workbook, including the workbook extension. This function h ...
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 extension. This is a great UDF (user define ...
- Free Excel UDF that displays the name of the Excel workbook without its extension. This is a great 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 located. There are no arguments for this ...
- UDF to return the name of the worksheet in Excel on which this function is located. There are no arguments for this ...
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 in Excel. This is a really simple a ...
- Return the date of the first Monday of any year with this UDF ISO Year function in Excel. This is a really simple a ...
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 (user defined function) that returns ...
- Return the ISO Week Number in Excel with this UDF. This is a simple to use UDF (user defined function) that returns ...
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 this UDF (user defined function) in ...
- Return the highest number between two numbers that is in a range of cells with this UDF (user defined function) in ...
Reverse the Contents of a Cell in Excel - UDF
- Reverse cell contents with this free Excel UDF (user defined function). This will mirror all cell contents regardl ...
- Reverse cell contents with this free Excel UDF (user defined function). This will mirror all cell contents regardl ...
Simple Excel Function to Combine Values in All Versions of Excel - UDF
- Excel function that combines values from multiple cells or inputs using a delimiter - works for every version of Ex ...
- Excel function that combines values from multiple cells or inputs using a delimiter - works for every version of Ex ...
Vlookup Function That Searches The Entire Workbook in Excel - UDF
- With this VLOOKUPWORKBOOK function, you will have to power to more quickly and easily analyse your data in Excel. ...
- With this VLOOKUPWORKBOOK function, you will have to power to more quickly and easily analyse your data in Excel. ...
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 week in the year on which a partic ...
- This is a WEEKNUM UDF for Excel. This allows you to determine the number of the week in the year on which a partic ...
Delete Blank Rows in Excel
- This is a macro which will delete blank rows in excel. This version will delete an entire row if there is a blank c ...
- This is a macro which will delete blank rows in excel. This version will delete an entire row if there is a blank c ...
Delete Duplicate Rows
- This macro will delete rows that appear twice in a list or worksheet. If two cells are identical, this macro will ...
- This macro will delete rows that appear twice in a list or worksheet. If two cells are identical, this macro will ...
Delete Empty Columns
- This macro will delete columns which are completely empty. This means that if there is no data within the entire co ...
- This macro will delete columns which are completely empty. This means that if there is no data within the entire co ...
Delete Entire Rows Based on Predefined Criteria (Text)
- This macro will allow you to specify certain criteria and then to delete rows based upon that criteria. You will c ...
- This macro will allow you to specify certain criteria and then to delete rows based upon that criteria. You will c ...
Delete Rows in Excel if Completely Empty
- This macro will delete only completely blank rows in an excel spreadsheet. It allows you to make a selection of row ...
- This macro will delete only completely blank rows in an excel spreadsheet. It allows you to make a selection of row ...
Add Background Photos / Images to Comments in Excel
- Add background images and photos to your comments in Excel with this macro. This macro uses a really cool feature ...
- Add background images and photos to your comments in Excel with this macro. This macro uses a really cool feature ...
Add Comments to Cells with an Excel Macro
- Add comments to cells in Excel with this macro. This allows you to quickly and easily add a comment to any cell wit ...
- Add comments to cells in Excel with this macro. This allows you to quickly and easily add a comment to any cell wit ...
Automatically Highlight the Active or Selected Cell
- This macro will highlight the active cell in any excel spreadsheet with a color selected in the code. This means th ...
- This macro will highlight the active cell in any excel spreadsheet with a color selected in the code. This means th ...
Create an Index / Table of Contents worksheet
- To create an Index / Table of Contents worksheet to a workbook: 1) Add a new worksheet and name it "Index" 2) Open ...
- To create an Index / Table of Contents worksheet to a workbook: 1) Add a new worksheet and name it "Index" 2) Open ...
Delete All Comments in a Worksheet in Excel Macro
- Excel macro that will delete all of the comment contained within the active or current worksheet in Excel. This mac ...
- Excel macro that will delete all of the comment contained within the active or current worksheet in Excel. This mac ...
Delete Comments in Excel - Permanently Remove Specific Comments from Excel
- Delete a comment in Excel with this macro. You can permanently remove or delete a specific comment or many comments ...
- Delete a comment in Excel with this macro. You can permanently remove or delete a specific comment or many comments ...
Delete Empty or 'Broken' Named Ranges (#REF!)
- This macro will delete named ranges which refer to empty or #REF! ranges. This means that if a named range has been ...
- This macro will delete named ranges which refer to empty or #REF! ranges. This means that if a named range has been ...
Delete Hidden Rows in a Workbook
- This macro will delete hidden rows from every worksheet in an entire workbook. However, note that this will only d ...
- This macro will delete hidden rows from every worksheet in an entire workbook. However, note that this will only d ...
Delete Hidden Worksheets
- This macro will delete all hidden worksheets within a workbook. When you run this macro a warning window will pop ...
- This macro will delete all hidden worksheets within a workbook. When you run this macro a warning window will pop ...
Delete Multiple Named Ranges Quickly
- This macro will allow you to delete multiple named ranges very quickly. When you run this macro, a message box will ...
- This macro will allow you to delete multiple named ranges very quickly. When you run this macro, a message box will ...
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 workbook. This means that all of the c ...
- This macro in Excel will display all of the comments within the entire Excel workbook. This means that all of the c ...
Hide Comments in Excel Completely - Even Indicators Will not Appear
- Hide all comments in an Excel workbook. No indicators will be displayed and comments will not appear when you hover ...
- Hide all comments in an Excel workbook. No indicators will be displayed and comments will not appear when you hover ...
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 the cells and users will also be a ...
- Hide comments in Excel with this macro. Comment indicators will still appear in the cells and users will also be a ...
Hide Specific Comments in Excel - Comments Will Still Display on Hover
- Hide specific comments in Excel with this macro. Comments are still visible on hovering over the cell that contain ...
- Hide specific comments in Excel with this macro. Comments are still visible on hovering over the cell that contain ...
Highlight the Column of the Selected Cell
- This macro will highlight the column of the active cell. This will fill the column of the active cell with a solid ...
- This macro will highlight the column of the active cell. This will fill the column of the active cell with a solid ...
Highlight the Row and Column of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill the column and row of the active ce ...
- This macro will highlight the row and column of the active cell. This will fill the column and row of the active ce ...
Highlight the Row of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill the row of the active cell with a s ...
- This macro will highlight the row and column of the active cell. This will fill the row of the active cell with a s ...
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 stored within every named range. ...
- List all of the named ranges in a workbook in Excel and the corresponding values stored within every named range. ...
Macro to add a New Line to Message Box Pop-up Windows in Excel
- This is a very simple Message Box, pop-up window, macro for Excel that illustrates how to put new lines, the same t ...
- This is a very simple Message Box, pop-up window, macro for Excel that illustrates how to put new lines, the same t ...
Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This m ...
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This m ...
Protect and Unprotect All Worksheets at Once
- This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn't allow you to input a pa ...
- This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn't allow you to input a pa ...
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 workbook. This means that this macro ...
- Excel macro that will remove/delete all of the comments from an entire Excel workbook. This means that this macro ...
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. This will make the desired comment ...
- This macro in Excel allows you to display or show a particular comment in Excel. This will make the desired comment ...
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 to worry about running a macro ever ...
- Automatically run an Excel macro at a certain time. This allows you to not have to worry about running a macro ever ...
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 was opened. This means that you can ...
- Run a macro after a certain amount of time has passed since the Excel workbook was opened. This means that you can ...
Close a Workbook after a Time Limit is Reached
- This macro will automatically close the workbook in which it is located after that workbook has been opened for a ...
- This macro will automatically close the workbook in which it is located after that workbook has been opened for a ...
Login to a Website using a Macro
- Connect and login to a website using a macro in Excel. This allows you to open a website and automatically login wi ...
- Connect and login to a website using a macro in Excel. This allows you to open a website and automatically login wi ...
Macro to Replace HTML Entities with Readable Text
- Excel macro that converts all HTML entities into their readable equivalent. This includes things like an ...
- Excel macro that converts all HTML entities into their readable equivalent. This includes things like an ...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOu ...
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOu ...
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear ...
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear ...
Print All Charts That are in a Worksheet
- This macro will print all of the embedded charts which are on the current active worksheet. Each chart will be pri ...
- This macro will print all of the embedded charts which are on the current active worksheet. Each chart will be pri ...
Print all Embedded Charts in the Entire Workbook
- This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet ...
- This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet ...
Print Entire Workbook in Excel
- This free excel macro allows you to print the entire workbook in Excel. You can easily set this macro to a button ...
- This free excel macro allows you to print the entire workbook in Excel. You can easily set this macro to a button ...
Print Preview Display for Specific Worksheets in Excel
- This free Excel macro allows you to display the print preview mode or window in Excel for a specified Excel workshe ...
- This free Excel macro allows you to display the print preview mode or window in Excel for a specified Excel workshe ...
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 for the current or selected workshee ...
- This free Excel macro allows you to display the print preview screen or window for the current or selected workshee ...
Print Preview Screen Display for The Entire Workbook in Excel
- This free Excel macro allows you to quickly and easily display the print preview window or mode for the entire Exc ...
- This free Excel macro allows you to quickly and easily display the print preview window or mode for the entire Exc ...
Print Selected Worksheets in Excel
- This free excel macro will print all selected worksheets in Excel. If there are no other worksheets selected the a ...
- This free excel macro will print all selected worksheets in Excel. If there are no other worksheets selected the a ...
Print Specific Pages in Excel
- This free Excel macro allows you to print a pre-specified selection of pages from Excel. This means you can print 2 ...
- This free Excel macro allows you to print a pre-specified selection of pages from Excel. This means you can print 2 ...
Print The Current Worksheet in Excel
- This free Excel macro will print the current active worksheet in Excel. This means that whatever sheet you are cur ...
- This free Excel macro will print the current active worksheet in Excel. This means that whatever sheet you are cur ...
Change Formulas to Absolute or Relative References
- This macro will change the formulas in cells to absolute or relative. It allows you to change the rows or the colum ...
- This macro will change the formulas in cells to absolute or relative. It allows you to change the rows or the colum ...
Change Text to Lowercase
- This macro will change all text within the selected cells to lowercase. It works only on selected cells within Micr ...
- This macro will change all text within the selected cells to lowercase. It works only on selected cells within Micr ...
Delete Only the Text from Cells
- This macro will delete all text from selected cells. This will not delete any other characters or numbers from any ...
- This macro will delete all text from selected cells. This will not delete any other characters or numbers from any ...
Hide Formulas in a Worksheet and Prevent Deletion
- This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protecte ...
- This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protecte ...
Highlight Cells which Contain Formulas
- This macro will highlight all of the cells in a worksheet which contain a formula. The first one listed will highli ...
- This macro will highlight all of the cells in a worksheet which contain a formula. The first one listed will highli ...
Highlight Cells with Text or Formulas (non-empty cells)
- This macro will highlight all cells in excel which are not empty. This means that if a cell contains formulas, text ...
- This macro will highlight all cells in excel which are not empty. This means that if a cell contains formulas, text ...
Remove (Delete) Hyperlinks from Worksheets
- This macro will remove all hyperlinks from the active worksheet. It will delete the hyperlinks but it will not dele ...
- This macro will remove all hyperlinks from the active worksheet. It will delete the hyperlinks but it will not dele ...
Replace Formulas with Values (For The Entire Workbook)
- This macro will convert every formula in an entire workbook into its respective value. This is basically a quick w ...
- This macro will convert every formula in an entire workbook into its respective value. This is basically a quick w ...
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 highlighted. This macro creates a n ...
- Create a 12 month formatted calendar on a new tab in Excel with the current day highlighted. This macro creates a n ...
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 on which you double-click. In the e ...
- This macro allows you to enter any text or number, that you specify, in a cell on which you double-click. In the e ...
List All Files from a Directory into Excel
- Get a list of all files from a directory into an Excel worksheet. This allows you to navigate to anywhere on your c ...
- Get a list of all files from a directory into an Excel worksheet. This allows you to navigate to anywhere on your c ...
Delete a VBA Module From Excel
- Delete a VBA macro module from Excel with this macro. This macro allows you to fully remove a macro module from Ex ...
- Delete a VBA macro module from Excel with this macro. This macro allows you to fully remove a macro module from Ex ...
Disables the "Save As" Feature in Excel
- This macro will disable the Save As feature in excel. This means that a user will not be able to resave the workbo ...
- This macro will disable the Save As feature in excel. This means that a user will not be able to resave the workbo ...
Prevent Saving a Workbook under a Different File Name
- This Excel macro prevents the user from saving an excel file or workbook under a different file name. The file can ...
- This Excel macro prevents the user from saving an excel file or workbook under a different file name. The file can ...
Open a PowerPoint Presentation from Excel
- This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the ...
- This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the ...
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word ...
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word ...
Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, fil ...
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, fil ...
Open Microsoft Outlook from Excel
- This free macro will open the Microsoft Outlook program on your computer. You do need to have this program first. ...
- This free macro will open the Microsoft Outlook program on your computer. You do need to have this program first. ...
Open Microsoft PowerPoint from Excel
- This free macro will open the Microsoft PowerPoint program on your computer. You do need to have this program first ...
- This free macro will open the Microsoft PowerPoint program on your computer. You do need to have this program first ...
Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This ...
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This ...