Change Capital Letters to Small (Upper, lower, Proper Case conversion using Excel/VBA)

Remove Color of all Sheet's tabs in Microsoft Excel

Close all Saved Workbooks in Excel Application

Delete 'n' characters from a range of cells in MS Excel

Split the Text with Newline Characters (Alt + Enter)

Load Array from Sheet Range

ADD ERROR TRAP: Wrap your Formulas with IFERROR or ISERROR

17 ways to Optimize VBA Code for FASTER Macros

Nth VLookup and HLookup Formulas (User Defined Function)

SHRINK REDUCE EXCEL FILE SIZE

Notifying with Flash Window or Message Beep

Speed up Excel Start up (FASTER EXCEL)