Using .Find with Hidden Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

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).
 
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
 
Right you are, thanks for the help.

Tom Ogilvy said:
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
Click to expand...
 
Back
Top