Get Values from 1st Row of Cells in EXCEL
Posted on 2006-11-13
I need the code that will do the following in EXCEL:
1) Go through the first row and get the value from each cell one at a time.
2) If the value in a cell is equal to "expected" then identify what the column is (A, B, C, etc.) and output that value (for the sake of this example just output to a msgbox).