Simple Convert Question

[Rocky0201]

I have a string that has a cell reference such as "A1". I would like to retrieve the column number and put it into an integer. Is this possible?

Thanks...

 

[schielrn]

I would like to retrieve the column number and put it into an integer.

What does this mean? Do you mean to say you want to convert the column Letter to a number?

 

[Rocky0201]

That's correct schielrn... I would have created a string with A1 through whatever. I would like to convert the letter A, B, C, etc... to 1, 2, 3, etc... I need to do this in my macro...

Thanks...

 

[schielrn]

In VBA to get the column letter just use:

columnNumber = range("D1").column

This just being an example.

 

[VoG]

For columns up to Z maybe

Sub colno()
Dim s As String, col As Integer
s = "J1"
col = Asc(Left(s, 1)) - 64
MsgBox col
End Sub

 

[Rocky0201]

Excellant!! Thank you both very much....