How do you Find with data in hidden columns

D

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
 
D

Dave Peterson

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

Dave Peterson

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

Don Guillett

Doesn't care if hidden.

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

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
 
Top