Thread
:
How do you Find with data in hidden columns
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
How do you Find with data in hidden columns
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett