Thanks to all those who answered this. I only need one, but this will help
me also.

"Toppers" wrote:

Function courtesy of Chip Pearson:


Function ColumnNumber(ColLetter) As Integer
ColumnNumber = Cells(1, ColLetter).Column
End Function



"slymeat" wrote:

Anybody have some code to convert a column letter to it's column number
equivalent?
--
Andrew