Excel VBA Examples

Swap Contents of Two Cells in Excel

This post will guide you how to swap contents of two cells in Excel. How do I swap cell contents with VBA Macro code in Excel. how to swap values between two cells in Excel. Swap Contents of Two Cells You can use a VBA Macro code to quickly swap contents of two selected cells… read more »

Rename Multiple Worksheets in Excel

This post will guide you how to rename multiple worksheets in your current workbook in Excel. How do I rename multiple worksheets at one time in Excel 2013/2016. How to rename one or multiple worksheet tabs in Excel. Rename Multiple Worksheets You can rename multiple worksheets manually by the following steps: #1 select one worksheet… read more »

Remove Trailing Spaces from Cells in Excel

This post will guide you how to remove leading and trailing spaces in cells in Excel. How do I remove leading or trailing spaces in a range of cells with a formula in Excel. How to remove trailing spaces from cells with VBA Macro in Excel. Remove Trailing Spaces from Cells with Formula If you… read more »

Convert Numbers into Words in Excel

This post will guide you how to convert numbers into words in Excel. How do I convert a numeric word into English words with VBA Function code in Excel. How to convert Numbers (Currency) to words with Excel VBA User Defined Function. Convert Numbers into Words The Excel doesn’t have a default function that displays… read more »

Hiding or Showing the Status Bar with Excel VBA

This post will guide you how to hide or display the status bar in Excel. How do I hide or display the status bar with Excel VBA macro code. Hiding Status Bar If you want to hide the status bar in your current workbook in Excel, you can use an Excel VBA macro to achieve… read more »

Reverse the Word Order within a Text String in One Cell

This post will guide you how to reverse the word order within a text string in one cell in Excel. How do I reverse list of words in a text string separated by space character with VBA Macro in Excel. Reverse Word If you want to reverse the word order in a text string in… read more »

Reverse Text String in Excel

This post will guide you how to reverse text string in Excel. How do I reverse text string in one cell with an Excel User Defined Function. How to reverse a text string in one cell with a formula in Excel. Reverse Text String with User Defined Function You can easily write down a User… read more »

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 »

Sidebar