Outlook VBA Macro Send Email at Specific Time using Delay Delivery Option. This delayed delivery is a built in function & available with each new email. Outlook will send email only at the time mentioned in this field.
How to Replace #N/A in Excel with 0 or blank – using Formula?
September 14, 2022
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
September 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?
September 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?
September 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
September 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
September 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
September 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
September 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
September 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 […]
