Hide and seek
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.
|