eed
07-13-2009, 01:37 PM
Hello, all! I receive a spreadsheet which gets automatically generated, and the columns aren't always in the same order. I need to run a procedure, but first I need it to determine which column contains a particular field. What I would like to do is:
1. Search for a defined string, like "Price." (Should use "Match exact cell contents" option. The strings I search for here appear only once in the workbook.)
2. When the string is located, store the column letter of its location (A, B,...) in a variable.
Can someone help me with the best way to search for a string, get the coordinates of the cell containing that string, and then store the column letter in a variable?
Many thanks in advance!!
Erin
1. Search for a defined string, like "Price." (Should use "Match exact cell contents" option. The strings I search for here appear only once in the workbook.)
2. When the string is located, store the column letter of its location (A, B,...) in a variable.
Can someone help me with the best way to search for a string, get the coordinates of the cell containing that string, and then store the column letter in a variable?
Many thanks in advance!!
Erin