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
Script to remove any duplicate values in a column.