Column number to letter

  • I want to insert a simple formula into a spreadsheet except the rows and columns are all in numbers.

    This is what I have:

    Sub display()
          For k = 5 to 35
              Range(Column(k) & "6") = k
          Next  k
     End Sub
     Function Column(Byval I As Integer)
          'convert number into column?
             Column Alpha
     End Function
  • Re: Column number to letter

    One of these two methods will work too.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!