How do you Find with data in hidden columns
Well duh. I should have though of this.
Thanks,
- Pat
"Dave Peterson" wrote:
Or you could loop through the cells in the header column looking for your key
value.
Dreiding wrote:
In Excel 2003, I use VBA code to find the column with a specific title.
The Find works well as long as the column is not hidden. Unfortunately it
has to be hidden and I don't want to hard-code the column address.
Suggestions welcomed!
Thanks - Pat
--
Dave Peterson
|