Save file to SQL database
Code to save a file as binary into SQL database. Can be used in Excel and Access.
Find out file size
Simple script to find the size of the file.
Identify duplicates with formula
This simple formula will show if there is another duplicate value.
Find last used row or column
There are different ways to find last row or column which is populated.
Convert Column Number to Letter Or Letter To Number
Easy way to convert column letter to a number and column number to a letter.
Check if value exists in range
Code to find a value within range without looping