Return Column Letter - MrExcel.com | Excel Resources | Excel Seminars | Excel Product

On 2002-12-18 17:44, Chris The Rock wrote: I just came across this formula that will give you the column letter - it's not VBA though. =MID(CELL("address",B1),2,1) I just thought this was cool. Had to share. Would it work if you replace B1 with AZ1? Try h

www.mrexcel.com