View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do you Find with data in hidden columns

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


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