Referring to a Column Number in vba code - Found Via Function using Column Letter

[R_S_6]

Hi All.

I found the following function on-line. It outputs the Column Number for a given Column Letter.

Please Login or Register  to view this content.

The user inputs a Column Letter into a userform textbox, 'TBCOL'. From the resulting column number from the function calculation, I wish to refer to this code in the following:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have tried the following in the Columns() section:

Please Login or Register  to view this content.

None of the above seem to work. Hopefully the power of the 'Excel Forum' will sort this in a jiffy.

Thanks in advance
Mark

[DonkeyOte]

In that context:

Please Login or Register  to view this content.

would suffice

FWIW if you need the column number far quicker to use something like:

Please Login or Register  to view this content.

[R_S_6]

Thanks for your reply.

I cant reference the textbox 'TBCOL' as it contains a Letter selected by the user for the column, for instance 'A'. I use the function to get the number of the column, in this case '1' that would then replace:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Thus allowing the resulting calculated column number to be a variable dependant upon the user selected column letter.

Hopefully the above makes things clearer?
I have tried your top piece of code with no luck - Any ideas?

Thanks for your help - its very much appreciated!
mark

[shg]

DO's suggestion should work fine. You can reference columns by letter, e.g.,

Please Login or Register  to view this content.

[R_S_6]

A Thousand Apologies! The Function was returning number '3' for column 'C' which is correct. What was incorrect is that I was supposed to be using column B i.e. 2!
Knowing that now - Both your suggestions are much much simpler and logical!

Thank you both - Apologies again!
Mark