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

Using .Find with Hidden Columns
 

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" wrote in message
...
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).

Using .Find with Hidden Columns
 

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" wrote in message
...
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).