Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro question? Column position
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro question? Column position
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro question? Column position
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro question? Column position
do you have an Insert=Name=Define
Name:= Test Refersto:=Sheet1!$E:$E or something like that. If not, that is why you get the error. If by named test, you mean E1 has the word Test in it. Sub AAA() Dim res As Variant, vVar As Variant res = Application.Match("Test", Rows(1), 0) If Not IsError(res) Then vVar = res Debug.Print vVar Else MsgBox "Not found" End If End Sub -- Regards, Tom Ogilvy "Arul" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row position of specified column and value | Excel Worksheet Functions | |||
function for Column Position | Excel Discussion (Misc queries) | |||
Excel formula to find position of the contents of a cell within a column. | Excel Discussion (Misc queries) | |||
Finding Column Position | Excel Discussion (Misc queries) | |||
#VALUE! position in column of data | Excel Programming |