Excel VBA Macro

How to Insert a comment into Multiple Cells in Excel

This post will guide you how to insert a comment into two or multiple cells in Excel. How do I add comment to multiple cells with VBA Macro in Excel 2013/2016. Insert Comment into Multiple Cells Assuming that you have a list of data in range B1:B5, in which contain some text values, and you… read more »

How to Select Only Cells with Data in Excel

This post will guide you how to select all cells with data in Excel. How do I select only cells with data using VBA Macro in Excel 2013/2016. Select Only Cells with Data Assuming that you have a list of data in range A1:B5, in which contain text values and blank cells, and you want… 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 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