Why do I need an "& 1" here?

[hitbid]

Why does this code require the "& 1" in the conversion from column letter to number?

Dim ColNum As Long
Dim ColLet As String


ColLet = InputBox("What is the column letter of the column you want to analyze?")
  
ColNum = Range(ColLet & 1).Column


MsgBox ColNum

If I remove the & 1 I get an error.

 

[alansidman]

A range represents a particular cell or group of cells. Without the & 1 you do not have a legitimate range. So if in the input box, a user responded "C", then the range would be "C1" which is a legitimate range to work with.

 

[footoo]

So that Range(ColLet & 1) produces a valid range ref (like A1, B1,etc.)

 

[hitbid]

Of course! Thank you.

I can change it to something like

ColNum = Range(ColLet & ":" & ColLet).Column

That is longer, but I get it.

My instinct confused me, because I want to type it out like this:

[COLOR=#333333]ColNum = Range(ColLet & "1").Column[/COLOR]