Finding a Date in Forumla via VBA

[Foreverlearning]

Hi,

I am having difficulty trying to find a date using VBA.

I have a date range like so.

Cell C5 =01/01/2012
Cell D5 =C5+1
Cell E5 = D5+1
Cell F5 = E5+1

Formatted as dd (day date only)

Which gives me the dates ok

When try to use find function in vba it just doesn't find any dates
This is what I have

Please Login or Register  to view this content.

rngDate always end up with nothing

How do I go about the correct way?

Thanks

[Sa DQ]

Please Login or Register  to view this content.

[Foreverlearning]

Hi,

Sorry, but I am a liitle confused as to what really is happening here.

But I can see that you have temporary formatted the dates to do a find then refromatted to original

Can I ask what is the (Randomize: jJ = 9 + Rnd() * 240 \ 1) for?

That is a bit confusing

Thanks
Lionel

[Sa DQ]

[C5].value => #1/1/2012#

In [D2] Add formula =9+INT(240*RAND())

And {ENTER}

[Foreverlearning]

Thanks Sa DQ

You have given me ideas for an alternative which works well.

Appreciate your help