View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dreiding Dreiding is offline
external usenet poster
 
Posts: 80
Default 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