View Single Post
 
Old 03-09-2012, 09:18 AM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default 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.
Reply With Quote