Using .Find with Hidden Columns

Is there a way to have the .find method look in hidden columns of data? Or
is my only solution to unhide all columns, perform the find, then rehide the
appropriate columns (all in VBA).

Tell the find function to look in xlFormulas and the hidden columns should
be searched.

rng = cells.find(what:="ABCD", Lookin:=xlFormulas, Lookat:=xlWhole)

as an example
--
Regards,
Tom Ogilvy

"D" <D@discussions.microsoft.com> wrote in message
news:C7F02BE9-7F56-4757-98AC-0C8DEEF65869@microsoft.com...
> Is there a way to have the .find method look in hidden columns of data?
Or
> is my only solution to unhide all columns, perform the find, then rehide
the
> appropriate columns (all in VBA).

Right you are, thanks for the help.

"Tom Ogilvy" wrote:

> Tell the find function to look in xlFormulas and the hidden columns should
> be searched.
>
> rng = cells.find(what:="ABCD", Lookin:=xlFormulas, Lookat:=xlWhole)
>
> as an example
> --
> Regards,
> Tom Ogilvy
>
> "D" <D@discussions.microsoft.com> wrote in message
> news:C7F02BE9-7F56-4757-98AC-0C8DEEF65869@microsoft.com...
> > Is there a way to have the .find method look in hidden columns of data?
> Or
> > is my only solution to unhide all columns, perform the find, then rehide
> the
> > appropriate columns (all in VBA).
>
>
>