Thanks for the response...

I'm getting the following error...
Method 'Range' of object '_Global' failed

Any idea why?

"JE McGimpsey" wrote:

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