Excel VBA Examples

Quickly Delete All Picture Objects

This post will guide you how to delete all picture objects in your current worksheet in excel. How do I delete all pictures or charts in your worksheet without having to select each one and delete them by manually in excel. How to delete all picture objects using VBA code in excel. You can use… read more »

Generate Random Character Strings

This post will guide you how to generate a random character string in excel. How do I create a random passwords, text strings with a formula┬áin excel. How do I generate random strings of characters with VBA code in excel. How to generate random alphanumeric values in excel. Generate Random Character Strings with Formula To… read more »

Convert Month Name to Number

This post will guide you how to convert month name to number in excel. How do I convert month name to number with an excel formula. How to convert month name to number with an Excel VBA macro. How to convert 3 letter month abbreviation to number in excel. How to convert 3 character month… read more »

Set Cell Color based on Another Cell Color

This post will guide you how to set the color of a cell based on another cell color in excel. How do I change the color of cells same as another cell in excel. how to set a cell color equal to another with VBA code in excel. Set Cell Color based on Another Cell… read more »

Selecting Diagonal Range

This post will guide you how to select a diagonal range in excel. How do I use diagonal cells to select a range in excel. How to create a new excel Macro code to select a diagonal range in the sheet. Select Diagonal Cells Assuming that you have a list of data, and you can… read more »

Clear Cell Contents and Formatting

This post will guide you how to clear cell contents and formatting at the same time in excel. How to clear cells to remove the cell contents , formats, and any attached comments. When you press delete key in your keyboard to clear one cell content, it only can be cell the cell contents without… read more »

Clear Cell on Open or Exit of the Workbook

This post will guide you how to clear the contents of a cell or range of cells on open of the workbook in excel. How do I clear cells before workbook close or open with VBA code in excel. How to clear cells on workbook open in excel. Clear Cell Content on Open or Exit… read more »

Break Links to Source Data in Chart

This post will guide you how to break all chart links to source data in excel. How do I break a link to source data in your selected chart in excel. Break Links to Source Data When you created a chart in your current worksheet, and when you modify the source data and the chart… read more »

Center an Image in an Excel Cell

This post will guide you how to center an image file in an excel cell. And how do I center to align a graphic in an excel cell. How to align a picture within a cell. How to align a picture to the center of a cell with VBA code in excel. Center an Image… read more »

Sidebar