Using .Find with Hidden Columns

[Guest]

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

 

[Tom Ogilvy]

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

 

[Guest]

Right you are, thanks for the help.

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