Convert column letter to numbers

[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

 

[Frank Kabel]

Hi Todd
try
=COLUMN(INDIRECT(W4 & "1"))

 

[Todd Huttenstine]

Thank you that was exactly what I needed.

Hi Todd
try
=COLUMN(INDIRECT(W4 & "1"))

 

[Rob van Gelder]

Since you asked for code.

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