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
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?
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?
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
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
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
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
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
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
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 […]