Excel Macro Class

We often copy/paste data, tables, and charts, from Excel to Word documents. In this post, we see how to automate that process with VBA macro...

The cell right-click menu in Excel, also known as context menu, is a fast way to see and change properties of a cell or range in the workshe...

This is an UPDATE to a previous post where we saw how to insert pictures from Google Drive in Excel using VBA macros. The method explained ...

In a previous post we learnt to import data from Google Sheets using a web query in Excel ( Import Data From Google Sheets ). We can actuall...

In this post we see how to unhide all sheets and cells in Excel using VBA macros. The macro loops through each worksheet in the workbook to ...

In this post we learn to separate words and numbers within cells in Excel using VBA macros. The macro splits the value in a cell into parts ...

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 learn how to upload or export data from Excel to Google Sheets using VBA macros. The macro sends a HTTP request to POST the ...

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 learn how to combine all the Excel files in a given folder using VBA macros. The macro triggers a dialog box to select a fol...

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 the previous post we have seen how to connect to a web API in Excel using VBA macros. In this post we see how to read the API JSON respo...

In this post we learn how to get data from a web API in Excel using VBA macros. As an example, we are getting data form a public API with in...

In a previous post we have seen how to sort text or words inside a single cell in the Excel worksheet using VBA macros. But that approach w...

In this post we see how to sort the text or words inside a single cell in the Excel worksheet using VBA macros. This may come handy when dea...

In the previous post we have seen how to send an HTTP request to get web data as text (Part 1). In this post we see how to process the resp...

In this post we learn how to send a HTTP request to scrape and import web data into Excel using VBA macros. As an example, we are getting da...

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