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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identify Hidden Columns 37
Sort partially hidden data 1
Macro to Hide/Unhide various columns 5
Identify Hidden Columns - New issue! 19
Hiding Columns produces error <----HELP PLEASE 2
Hide unhide non-contiguous columns 6
operate macro across multiple sheets, error, cannot locate solutio 3
How do you Find with data in hidden columns 5

Back
Top