one way:

Dim var As Long
var = Range("TEST").Column


In article ,
"Arul" wrote:

Say I have a column name "TEST". I would like to find the position of this
column and then assign this number to a variable.

If "TEST" is the fifth column in the spreadsheet...then the resulting value
I'm looking for is var = 5