Excel Macro question? Column position

[Arul]

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

Anyone?

Thanks

 

[JE McGimpsey]

one way:

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

 

[Arul]

Thanks for the response...

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

Any idea why?