467,151 Members | 920 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,151 developers. It's quick & easy.

Run-time error 91

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
  • viewed: 987
Share:

Post your reply

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

Similar topics

3 posts views Thread by leroybt.rm | last post: by
13 posts views Thread by Bob Day | last post: by
19 posts views Thread by Bryan | last post: by
9 posts views Thread by Brett Wesoloski | last post: by
8 posts views Thread by David Thielen | last post: by
3 posts views Thread by traceable1 | last post: by
7 posts views Thread by mxdevit@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.