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).