Query on small piece of code
Hi Mike
you probably have no cells selected when you invoke this macro which
contains your search string.
--
Regards
Frank Kabel
Frankfurt, Germany
Mike wrote:
I have the following very simple piece of code as part of a macro:
Selection.Find(What:="01/08/2002", _
After:=ActiveCell, _
LookIn:=xlFormulas, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False).Activate
Quite simply, in a row that is selected, the instruction is to
activate the cell where it finds the date shown.
I have recorded this through simply "doing a Ctrl+F" with the
recorder
running, but when I run this macro to check it keeps failing.
Any ideas on what the problem is as it's driving me mad, I can't see
what's wrong.
Thanks in advance
Mike
|