BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

Is64Bit

Determine if system is 64 bit or not. Related to

RmDir

Delete a folder, expects to be an empty folder, path must be already MapPathed

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

FindFile

Finds if a workbook is open or not in same Excel session

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

WelcomeSheet.zip

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

XorC

Simple small function to Encrypt or Decrypt a string in cell Test_XorC is for ...