Code to save a file as binary into SQL database. Can be used in Excel and Access.
There are different ways to find last row or column which is populated.
Easy way to convert column letter to a number and column number to a letter.
Code to find a value within range without looping
Useful trick to stop Excel from calculating formula when not needed.
Simple guide to various cell formatting in VBA