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

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

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.

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

Please Login or Register  to view this content.