In cell b105 I have a number which is a variable. In cell b106 I wish to show the cell reference which is row one and whatever column number is in cell b105. So for example if cell b105 equals 26 then in cell b106 I wish to have the cell reference Z1 (because Z is the 26th column on the sheet). If b105 equals 1 then b106 equals A1 etc.