Try using Cdate(Mydate) in Find
On Tue, Jul 26, 2011 at 9:44 AM, Tom <tcli...@gmail.com> 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". Can anyone help me? Thanks.
>
> Sub FindDate()
> Dim myDate As Date ' possibly incorrect
> myDate = Application.InputBox("What date are you looking for?",
> Type:=1)
> Cells.Find(What:="myDate", After:=ActiveCell, LookIn:=xlFormulas,
> _
> LookAt:=xlPart, SearchOrder:=xlByColumns,
> SearchDirection:=xlNext, _
> MatchCase:=False, SearchFormat:=False).Activate
> End Sub
>
> Tom
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Regards
Vasant
skype Id: vasantjob
http://facebook.com/vasantjob
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
