How do you Find with data in hidden columns

[Dreiding]

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]

Turn screenupdating off.
Unhide the columns
do the find
hide the columns
turn screenupdating on

 

[Dave Peterson]

Or you could loop through the cells in the header column looking for your key
value.

 

[Don Guillett]

Doesn't care if hidden.

Sub findhiddencol()
MsgBox Rows(1).Find("specific title").Column
End Sub

 

[Dreiding]

Don,

I'm sorry to say, at least for my environment, it does care if the column is
hidden.
I'm using Dave Peterson suggestion of looping through each cell.

- Pat

 

[Dreiding]

Well duh. I should have though of this.

Thanks,
- Pat