colNum = Range(colLetter & "1").column

where colLetter is a variable with the letter(s) in it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"slymeat" .(donotspam) wrote in message
...
Anybody have some code to convert a column letter to it's column number
equivalent?
--
Andrew