By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,593 Members | 2,006 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,593 IT Pros & Developers. It's quick & easy.

Run-time error 91

P: 1
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
Nov 16 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.