I tested it with dates that exist but still got the same error
message.
You can try it.
Tom
On Jul 26, 3:42 pm, "Rajan_Verma" wrote:
> If error is coming it means yourdatenot found in that sheet..
> ' On the Top on Module
> On Error Goto Err:
>
> 'Before End sub Statement
> Err:
> If err.number<
If error is coming it means your date not found in that sheet..
' On the Top on Module
On Error Goto Err:
'Before End sub Statement
Err:
If err.number<>0 then
Msgbox " Date Not Found",vbinformation
endif
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegro
Try using Cdate(Mydate) in Find
On Tue, Jul 26, 2011 at 9:44 AM, Tom wrote:
> I want the macro below to accept any date that I enter in its input
> box, e.g. 17/06/2011, and go and find it in the active worksheet. I
> got an error message saying, "Object variable or With block variable
> not set
