Excel VBA Examples

How to Highlight Cells Containing Formulas in Excel

This post will guide you how to highlight cells in which contain formulas using Conditional Formatting feature in Excel. How do I conditionally format a cell if it contains formula using a User defined function in combination with Conditional Formatting feature in Excel 2013/2016. Method1: Highlight Cells Containing Formulas Using Defined Name Method2: Highlight Cells… read more »

How to Use Outlook, Word and Excel to Send a Mass Emails

This post will guide you how to send mass emails to a list from an Excel Spreadsheet using Outlook. How do I send email to a list recipients using Excel and Outlook. Sending Email to A List of Recipients Sending Email to A List of Recipients Using VBA Macro Sending Email to A List of… read more »

How to Filter Cells with Bold Font Formatting in Excel

This post will guide you how to filter cells with bold font formatting in Excel. How do I filter cells with bold font formatting with VBA Macro in Excel 2013/2016. Filter Cells with Bold Font Formatting Assuming that you have a list of data in range B1:B5, in which contain text values, and you want… read more »

How to Limit Scroll Area in Excel

This post will guide you how to define a scroll area to a specific range in your worksheet in Excel. How to limit the scroll area for a worksheet via VBA macro in Excel. Define a Scroll Area Limit Scroll Area via VBA macro Define a Scroll Area If you want to define a scroll… read more »

How to Get the Data Size of Each Worksheet in a Workbook

This post will guide you how to check the size of each worksheet of workbook in Excel. How do I get the data size of each worksheet in a workbook in Excel 2013/2016. Assuming that you have a Workbook which contains multiple worksheet, and you want to know the data size of each worksheet in… read more »

Excel: Always Match Destination Formatting while Pasting

This post will guide you how to retain the text format always match destination formatting while copy/paste content in Excel. Is there a way to set default to always match destination formatting when pasting into Excel. When you copy data from a word document or other external application, Excel will use the original formatting for… read more »

How to Extract Number from Text String in Excel

This post will guide you how to extract number from a given test string in Excel. How do I extract all numbers from string using a formula in Excel. How to get all number from a given test string using user defined function in Excel. Extract Number from String with Formula Extract Number from String… read more »

How to Filter Data with Strikethrough Format in Excel

This post will guide you how to filter or delete rows with strikethrough format in your selected range of cells in Excel. How do I Filter by strikethrough formatted text with Find and Replace function in Excel 2013/2016. Or how to find cells with strike through formatting in Excel. Filter Data with Strikethrough Formatting Using… read more »

How to Move Every Other Row to a New Column in Excel

This post will guide you how to move every other row to a new column in Excel. How do I move every odd row to another column with formula in Excel 2013/2016. How to move every even row to other column in Excel with VBA Macro in Excel. Move Every Other Row to New Column… read more »

Sidebar