Excel VBA Examples

Excel Sum Numbers Ignore Text

This post will guide you how to sum numbers ignore text in same cell in Excel. How do I sum numbers with text appended in the same cell with a formula in excel.How to sum only numbers in a cells with text and numbers using User Defined Function in Excel. Sum Numbers Ignore Text To… read more »

Deleting Multiple Blank Columns

This post will guide you how to quickly delete multiple blank columns in a selected range of cells in Excel. How do I delete blank columns or rows with go to special feature in Excel. How to delete all empty columns in a selected range in Excel. Assuming that you have imported data from an… read more »

Insert The File Path and Filename into Header or Footer

This post will guide you how to add the file path and filename into a header or footer in Excel. How do I insert the file path and filename into the current worksheet header or footer in Excel. Insert The File Path and Filename into Header or Footer If you want to put a file… read more »

Merge Multiple Cells into One Cell with VBA

This post will guide you how to combine multiple cells into one cell with VBA code in Excel. How do I concatenate a range of cells with VBA macro in Excel 2013/2016. How to merge the contents of two or multiple cells into one cell with macro in Excel. Merge multiple Cells into One Cell… read more »

Close and Reopen the Current Workbook

This post will guide you how to close the current workbook with shortcut in excel. How to close and reopen the current workbook with shortcuts in excel. How to close and reopen the current workbook with VBA macro code in excel. How do I close a reopen the current workbook without saving in Excel. How… read more »

Export Excel Worksheet to Text File

This post will guide you how to export a worksheet to a text file in Excel. How do I convert a worksheet into a text file in Excel. How to use VBA macro to export the current worksheet to text file in Excel. Export Worksheet to Text File If you want to export a worksheet… read more »

Remove All Checkboxes

This post will guide you how to delete all checkboxes at once in the active worksheet in Excel. How do I remove all checkboxes in a range of cells in Excel. How to quickly remove all checkboxes with VBA macro in Excel. Assuming that you have lots of checkboxes in a range of cells, you… read more »

Create a calendar

This post will guide you how to create a monthly calendar with VBA code in Excel. How do I create a calendar with calendar template in excel. How to create a yearly calendar in Microsoft Excel. Create a Yearly Calendar You can use the Calendar template to create a yearly calendar, just do the following… read more »

Copy Worksheet multiple Times

This post will guide you how to copy a base sheet multiple times in the current worksheet in Excel. How do I copy one sheet multiple times with VBA code in Excel. Or how to copy multiple sheets to a new workbook in excel. Copy Worksheet Multiple Times If you want to copy the current… read more »

Multiply or Divide a Range of Cells with by a Number

This post will guide you how to multiply or divide a range of cells by a number in Excel. How do I multiply or divide entire range by the same number with VBA Macro in Excel. Assuming that you have a list of data (A1:A5) that you want to multiply or divide the selected range… read more »

Sidebar