VBA column header vs first row text
I want to perform an action on rows within a column. I want to get the column header letter(s) of the column whose first row contains a known value.
For instance, if the first row of column N shows "Price", I want to retrieve the N for using in a range select. The columns that I will be working with are not fixed.
Can someone help the Excel object model noob with this? Muchos gracias.
|