If the column number is in A1, you can use this formula (tested only a little
bit)

=IF(INT((A1)/26)0,CHAR(64+INT((A1)/26)),"")&CHAR(MOD(A1,26)+64)

"Quinn Ramsey" wrote:

I am working in excel and am placing a formula in diferent cells. I would
like to be able to convert a column number to the letter representation.
such as 1 would be A and 27 would be AA and so on. Here is the code I am
working with.

For col = 1 To 16 Step 1
If Cells(1, col) Cells(1, 1) Then
Cells(4, col).Formula = "=LOOKUP(" & toLetter(col) & "4,2:2,3:3 )"
End If
Next col

It it the toLetter(col) that i need to work. I know that function doesnt
exist by that name. Any help on how to do this in excel would be greatly
appreciated. Thanks

-Quinn