Category Archives: VBA For Excel

How to delete columns in Excel using VBA

In this article we will see how to delete columns in Excel using VBA. Example 1: Delete an entire column in a sheet using column number: Say, the Excel data that is of the form below and you need to delete the column for May-18

How to Use VBA to Pull Excel Data from Hyperlinks

In this article, we will look at how to extract data from a website using VBA. For this we will be using the navigate method on the InternetExplorer object. Let us see this in detail. Example 1: Say, you want to pull the current temperature of