Skip to main content
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: Sort Worksheets by Name
If you want to sort multiple worksheets by name, it seems very boring to do it manually. In this situations, you can use this simple macro.
UCase function
Returns a Variant (String) containing the specified string, converted to uppercase. Syntax UCase(string) The required string argument is any valid string expression. […]