Excel VBA Macro

Delete All Hidden Rows or Columns in Excel

This post will guide you how to delete all hidden rows or columns in Excel 2010/2013/2016. How do I efficiently delete all hidden columns and rows in a worksheet in Excel. How to delete all hidden rows or columns with VBA macro in Excel. Delete All Hidden Rows or Columns in Excel If you want… read more »

Find and Replace Multiple Values in Excel

This post will guide you how to find and replace multiple values at once with VBA macro in Excel. How do I make multiple find and replace in Excel. Find And Replace Multiple Values in Excel Assuming that you have a list of data in range B1:B6, and you want to find multiple values and… read more »

Change Uppercase to Title Case or Sentence Case in Excel

This post will guide you how to change uppercase letters to sentence case with a formula in Excel. How do I change uppercase to title case in Excel. How to change Uppercase to title case or sentence case with VBA macro in Excel. Change Uppercase to Title Case If you want to change uppercase letters… read more »

Convert Column to Comma Separated List in Excel

This post will guide you how to convert column list into a comma separated list in one cell in Excel. How do I convert a column into a comma separated list with a formula in Excel. Or how to convert a column into comma delimited list in Excel. Convert Column to Comma Separated List in… read more »

Removing Dash Characters in Excel

This post will guide you how to remove all dash characters from a text string in one cell in Excel. How to remove dashes from social security numbers in a cell with a formula in Excel. Removing Dash Characters If you want to remove all dash characters in one cell in Excel, you can use… read more »

Create Folders based on Cell Values with VBA

This post will guide you how to create folders based on cell values in the current worksheet in Excel. How do I automatically create folders based on cell values with VBA macro in Excel. How to use VBA macro to create folders bsed on cell values in Excel. Create Folders based on Cell Values Assuming… read more »

Insert Created Date and Last Modified Date in Cells

This post will guide you how to insert the created date and last modified date of the current workbook in a cell in Excel. How do I insert the date an excel workbook was last modified in a cell. How to insert last modified date in Excel. Insert Created Date and Last Modified Date in… read more »

Copy and Paste Only Non-blank Cells

This post will guide you how to copy and paste only non-blank cells in Excel 2013/2016. How do I copy only non blank cells with VBA code in Excel. Or how to get non-blank cells from a range of cells with a formula in Excel. This post will introduce four methods to copy and paste… read more »

Removing Non Numeric Characters

This post will guide you how to remove non numeric characters from cells with a formula in Excel. How do I remove non-numeric characters in cells in Excel. How to remove non-numeric characters from cells with VBA Code in Excel. Or how to strip out non-numeric characters from a given cell in Excel. Removing Non… read more »

Select All Objects

This post will guide you how to select all the objects in your current worksheet in Excel. How to select all pictures in Excel. How to find all objects and then select all of them in Excel. How to select all charts in the current worksheet. Select all objects If you want to select all… read more »

Sidebar