View Single Post
  #5   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

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


"Don Guillett" wrote:

Doesn't care if hidden.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dreiding" wrote in message
...
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