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