Convert column letter to numbers

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Hey guys

In cell W4 I have column letters. I would like to convert them to numbers.
For example, the value of cell W4 is currently "AJ". If you were to count
the columns, AJ would equal 36. What is the code to put the number 36 in
cell W5?


Thank you
Todd Huttenstine
 
Since you asked for code.

Range("W5").Value = Range(Range("W4").Value & "1").Column
 
Back
Top