How to replace #N/A in Excel with 0 or blank values using formula. Usually a formula like Vlookup returns such errors & this Excel function can handle this.
Outlook VBA – Sort Emails by Date – in a Folder
May 14, 2022
Get Outlook vba code to sort emamils by date in the inbox or in any folder. This code can sort the emails by oldest first/newest firlst as per your choice.
How to remove Drop down list in Excel?
May 14, 2022
Learn how to remove a drop down list in Excel using these simple steps. This trick is a quick shortcut just by using copy paste method.
How to create drop down list in Google sheets?
May 14, 2022
Learn how to create a drop down list in Google spreadsheet using the built in Data validation option, just similar to the MS Excel dropdown lists.
VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets
May 14, 2022
Learn VBA to unhide all sheets in a Excel workbook. This code sets visibility property of sheet to unhide even the very hidden sheets.
VBA Userform – Escape key to Close – Unload form
May 14, 2022
Learn how to close a vba userform with escape key. Map command button to Exit or Close a Userform with Escape key.
VBA to open or save Word document Protected or Encrypted with password
May 14, 2022
Use this VBA code to password protect or unprotect the Word document while openening the file. This macro also handles readonly protection, Write protection etc., right within the code itself.
VBA Get Numbers with in a String
May 14, 2022
Excel VBA code to get all digits or numbers with a string. This function extract only the numbers from with in a string text.
Convert a XML file into a Excel Sheet
May 14, 2022
VBA Loads a XML file into a Excel Sheet An XML file is like a simple text file but structured in a predefined format using tags. Sometimes you need to view an XML file and do calculation on the data using Excel. The code below is used to open an […]
Excel VBA Code to Checks if File Exists in Path
May 14, 2022
Finding an existing file & its path using Excel VBA When writing Excel VBA code that works with external files like XML or JSON, it is important that you have controls in your code to check it the file exist. If your macro (VBA program) doesn’t find a file when […]
