How do I get Column no, instead of Column letter

[rcarroll]

Hi, is there a function or property that will give me the column number (e.g. 1) if I provide the column letter (e.g. "A"). TIA

 

[gnaga]

Use

Range("A1).column if you use VBA

=Column(A:A) if you use formula function

GNaga

 

[Paul B]

=COLUMN(B1)

 

[rcarroll]

Thanks for reply. What I really need is some VBA that returns "1" when I give it "A". For example:

MyNum = Columns("A").Number

Thanks again.

 

[gnaga]

That's what I have given for you

MyNum = Range("A:A").Column will return 1 in variable MyNum

GNaga

 

[rcarroll]

Thanks. Exactly what I needed.