Excel Get number of column that is named X

[Matt-Boy]

I know I can do this with a long repeat loop through every cell, but I figure there must be a shorter method.

Looking to get the column number in the header row (row 1) where the string value is a certain value. Basically, I want to find out that column 7 is the one with the header name “NAME” so I can refer to that column later. I want this so my script won’t be broken if someone changes the column order in the source spreadsheet.

Tried:
get column of (every cell of row 1 whose string value is “Name_Here”)

And variations of that but I’m still not getting it. Maybe it’s not possible without looping through all the cells one by one.

Any ideas?

Model: iMac Intel 10.5.5
Browser: Firefox 3.0.2
Operating System: Mac OS X (10.5)

[Matt-Boy]

tell application "Microsoft Excel"
   set t_index to first column index of (find row 1 what "Name_Here" look in values look at whole)
end tell

Yeah, that’s what I was talking about.

Perfect. Thanks!