Find Method error: -Object variable with block set variable not set

Hi all again
I have a code exported from other wb which worked normally.
When it was imported into new wb Find method gives an error RunTime 91 Object variable with block set variable not set

Please Login or Register  to view this content.

I just want to find column number of today's date and us it in Cells()
I was able to do it on old wb but not here

Thanks in advance...

Can't tell what your variables are declared as,nor what value you have given to say Mydate

The reason for the error is that the date was not found, so the range returned by the Find is Nothing, and Nothing doesn't have a Column property.

If the date is actually there, then you might try

Please Login or Register  to view this content.

Here's the dummy
This userform is used just to add hours to workers

Maybe to try declare MyDate as long and use this instead of TDateCNum = Cells.Find(What:=CDbl(MyDate), LookIn:=xlValues).Column

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save