Excel Macro Class

In this post we see how to export data in Excel as PDF using VBA macros. The data can be a range or table in a worksheet, the whole workshee...

Arrays are used to store sets of data. A range with data in Excel can be stored in a two-dimensional (2D) array. A column or row are also Ra...

In a previous post we saw how to apply conditional formatting rules in Excel with VBA macros. In that example, formatting was applied to a ...

Microsoft Excel allows to sort a range based on cell values, cell and font color, and conditional formatting, in ascending or descending ord...

In this post we see how to add consecutive numbers to cells in the Excel worksheet using VBA macros. We review two simple options: 1. Using ...

There are several ways to clear cells based on cell value with Excel VBA. The easiest, and probably also most efficient way to do it is usin...

Conditional formatting is a feature of Microsoft Excel that allows highlighting certain values to easily identify those cells. Excel offers ...

In this post we see how to delete rows based on given criteria in Excel using VBA macros. The macro loops through each row with content in t...

In this post we see how to consolidate filtered data from multiple sheets into separate sheets for each unique entry using Excel VBA macros....

In this post we see how to copy each column with data to a separate worksheet in Excel using VBA macros. This is useful when dealing with ma...

In this post we learn to stack or combine multiple columns into a single column in Excel using VBA macros. Depending on the scenario, that’s...

In this post we see how to strikethrough the text in a cell in Excel using VBA macros. The macro example consists of an event procedure trig...

In this post we see how to group cells or rows with the same format in Excel using VBA macros. Grouping cells or rows in Microsoft Excel is ...

In a previous post we saw how to Compare Two Worksheets in Excel using VBA macros. In this post we see how to compare two columns with data...

In this post we see how to sort and merge a group of cells with the same value in Excel using VBA macros. Selected values are sorted in asce...

In a previous post we have seen how to autofill table gaps in Excel using VBA macros. In this post we see another way to do it with less co...

In this post we see how to split text into columns in Excel using VBA macros. The macro splits the text in one column into as many columns a...

Sometimes we need to manually create a table with many repeating terms and is time-consuming to use Excel’s AutoFill/FillDown or Go To Speci...

In a previous post , we have seen how to get a list of unique entries in Excel using VBA macros. Now we are going to add a validation list w...

We can easily filter data within columns in Excel. Sometimes we need however to get the list of those unique entries Excel is showing to fil...