finding value in a hidden sheet
My code seems to fail because I am searching a value in a
hidden sheet. Any idea?
I get the following message (runtime error 1004, activate
method out of range class failed)
Dim Cell As Range
Set Cell = Range("List").Find(What:=Range("nametofind"))
Cell.Activate
PS: list and nametofind are defined names
|