Excel Macro Class

In this post we see how to convert a range with data into a table with Excel VBA macros. They are different VBA objects altogether – Range v...

Microsoft Excel lets you create your own custom functions, which are generally called user defined functions (UDFs). These are Function proc...

Microsoft Excel has a broad choice of dialogs available (file dialogs, color and formatting dialogs, etc.). In this post we see how to launc...

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...

We have seen how to send and received emails from/to Excel via Outlook using VBA macros. In this post we see how to send meet invites from E...

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...

This simple macro example adds as many sheets to the workbook as cells in the selected range. The name of each sheet corresponds to the valu...

We can add a chart in Excel with just one line of VBA code specifying a range with source data. Then we can add as many series (i.e. lines, ...

We saw before how to send emails from Excelvia Outlook . We can also extract emails from Outlook into Excel. For that, we need to target the...

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 ...

In a previous post we saw how to send emails from Excel via Outlook and from a Microsoft email account. We could use the same method to send...

In this post we see how to export or save a range with data as a picture. This can be useful to share certain data, table, pivot, etc, as an...

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

Slicers are a cool feature initially used only with pivots that Microsoft Excel 2013 and following versions made available for data tables t...

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 ...

In a previous post, we saw how to insert a picture from the web in Excel:   Insert Picture From Web URL . We can insert a local picture usin...

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 a previous post , we have seen how to send an email from Excel (via Outlook) using VBA macros. We can add as many recipients as needed se...

In this post we see how to convert a range with data in Excel into an HTML table. We may want to get Excel data as an HTML table for example...