Hi everybody,
For sure an easy thing for you to solve.
But for me as non expert I cannot find the mistake.
I wrote an easy find command as shown here
Range("A:A").Select
Cells.Find(What:="01/11/2005", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=True).Activate
Just recording the Macro worked. If I copy it as part into another Macro I receive the Run-time error 91 message
Object variable or With Block variable not set.
The date format I included in the above find command is the one I see in the Excel cell I refer to. The format itself is specified as custom "mm-yyy".
Can somebody help me out?
Thanks in advance,
Newcomer
|