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
November 25, 2024
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 Hyperlink Follow – URL within Macro
November 25, 2024
How to Click Hyperlink in Excel with VBA Macro? There are 2 methods available to click a hyperlink in Excel. Both the methods do open the URL in the default browser or open the corresponding file in the default application. Here is the code demonstrates both methods. Sub follow_hyperlink() ‘Follow […]
Excel VBA Count #N/A Errors
November 25, 2024
How to count number of #N/A error in Excel? Number of occurrence of #N/A error in a column can be found by using the formula: Countif(<column>,”#N/A”) Consider, You havefew vlookup formula in column D. Out of it, few resulted in #N/A error. To get the count of this error in […]
Excel VBA Delete all #N/A
November 25, 2024
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
November 25, 2024
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, […]
List all windows UserNames & Domain in VBA
November 25, 2024
List all User Accounts in Windows using VBA In vba use this code to get windows user account names & their domain names. Copy paste this code into your Excel vba project module. Run the code by pressing F5. You will get a complete list of use account names and […]
Vba Get Computer Name using environment variable
November 25, 2024
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 […]
Get Current Date in Vba
November 25, 2024
Display Today’s Date & Time in VBA Function used to displaz the current date / time is Vba.Now() This function will return the date & time in this default format: 7/14/2029 11:34:31 AM The returned output can be formatted into any desired format as given in the below code snippet. […]