Get an EXCEL cell address from its row/column number - VBA Visual Basic for Applications (Microsoft)

Another deceptively simple thing to want to do, but it took me an age to find this gem. Say you've got a cells row and column number and you want to return its cell reference in the format A1 or B5 etc . For example, the cell at row 34, column 78 equates

www.tek-tips.com