It's better to specify all the parms to the .find method. If you don't, you'll
be inheriting the settings from the last .find -- either in code or manually by
the user.

Then try looking in xlformulas.

Dave wrote:

Hi all,
XL2003
I am using the following lines in part of a proceedu

With Sheets(A).Range("D9:D1000")
Set C = .Find(B, LookIn:=xlValues)
If Not C Is Nothing Then
(More code here...)

This works as expected, until I hide column D on Sheets(A). (ie: when D:D is
hidden, C is Nothing). I would really like to keep this column hidden. Is
there a reasonably tidy solution, or does the 'Find' function intentionally
overlook hidden cells.
Thanks in advance.
Regards - Dave.

--

Dave Peterson