Excel VBA Macro

How to Insert Cell Content into Header or Footer in Excel

This post will guide you how to insert the contents of a paricular into the header or footer cell in your active worksheet in Excel. How do I put a cell value into header or footer in all worksheets in your active workbook using VBA Macro in Excel. Insert cell Content into Header or Footer… read more »

How To Convert Text Case into Uppercase or Lowercase in Excel

This article will introduce two ways to change test case in Excel. You can perform UPPER\LOWER\PROPER functions to convert text into uppercase or lowercase letters in Excel , and you can also use VBA macro to perform the task. Select one you like, and let me show you the methods. You may meet the situation… read more »

How To Set paste Values as Default Paste in Excel

This post will guide you how to set paste values as default paste in Excel. How do I set the default paste special in Excel to paste only values when using Ctrl+v keys. when you want to copy data from a selected range of cells and then pasted it to another range with Ctrl +… read more »

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 »

Sidebar