Skip to main content
Excel Macro: Using Regular Expressions
Sometimes, Excel's built-in find-replace function doesn't meet our needs, and this time you can consider using regular expressions in Excel. To use […]
Excel Macro: Convert Numbers Into Words
Excel does not have a default function to display numbers as English words in a worksheet, but you can do it with […]
Excel Macro: Convert Current System Time to ISO 8601 UTC Time Stamp
The Excel VBA Now function is a built-in function in Excel that return the current system date and time, but not contains […]
Excel Macro: Base64 HMAC Encryption
Some APIs require each REST request to be signed with an HMAC SHA256 signature, and these signatures need to be converted to […]
Excel Macro: Determine If a Excel Workbook is Already Open
This Excel custom function can be used to determine if a excel workbook is already open or not. Get this VBA code now!
Function statement
Declares the name, arguments, and code that form the body of a Function procedure. Syntax [Public | Private | Friend] [ Static […]