Clear Excel VBA Immediate Window Manually There is no explicit option to clear immediate window. Just select all content in Immediate window using control + A, then press delete button. This is the only option to clear the data in this window. Excel VBA Code to Clear Immediate Window As […]
Vba Check if Sheet Exists – If not Create
VBA Code to Check if Sheet with Name exists? This Excel vba code will check if sheet with a specific name exists in the workbook. As per Microsoft specifications, You can add as many number of sheets depending on the limits of Your computer’s memory. So, this loop will check […]
Rearrange Excel Sheets in Custom or Alphabetic Order with VBA
Custom Order or Alphabetical Order This page has VBA code that can arrange worksheets in a Excel file in: Custom Order as per user preference Alphabetic Order of the Sheet Names Lets get the code. VBA Code – Arrange Sheets in Custom Order To make the below code work, You […]
Excel VBA Comment Multiple Lines – Easy Menu Option
In Excel VBA comment multiple lines of code using this toolbar option. This can comment a block of selected lines of code or uncomment them.
Excel VBA Delete all #N/A
VBA code to delete all #N/A error in Excel #N/A error can occur as a return code from any Excel formula like Vlookup, Lookup etc., If you copy paste data only from a worksheet that has formula, then this #N/A error will occur as a string value. You can remove […]
Hyperlinks Index – Get all links with address, cell – Whole Workbook
Get list of all Hyperlinks in Excel file This macro produces a hyperlink index sheet. To get list of hyperlinks in each worksheet, the Vba code in this page follow these steps. Add a new sheet for Output Loop through each Worksheet Loop thru each hyperlink Get hyperlink address, path, […]
Vba Get Computer Name using environment variable
Find Computer Name in Excel VBA In this page, get three different vba code to get Computer name. Environment variable Windows Api wScript.Network To get the computer name or the host name there can be more multiple ways. But, one of these could serve the purpose. 1. Get Computer name […]
How to do Spell Check in Excel?
How to spell check in Excel? Easy steps to invoke checkspelling module in Excel cell, range, worksheet or word thru menu and VBA Macro,
Excel VBA Remove Duplicates Values
Get code in Excel VBA to Remove Duplicate values from Worksheet Range or Column etc., This code uses the Excel’s built in Remove duplicates option
How to Web Scrape with VBA using IE & Parse HTML?
Get VBA code to web scrape using IE & then parse HTML data from website. The extracted website data is Parsed within Excel VBA code itself.