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

[bambino_32]

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...

[royUK]

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

[bambino_32]

Here are declared valriables

Please Login or Register  to view this content.

TDayButton is OptionButton name. It checks if it's selected

[shg]

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.

[bambino_32]

he reason for the error is that the date was not found

The date is there and unfortunately it didn't work

I'm working at dummy so I upload one soon...
Thanks al lot

[bambino_32]

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

[bambino_32]

oh guys please help me. it's very important for me....((((

[bambino_32]

bump
please))))

[bambino_32]

bump((((((((((((((((((((

[bambino_32]

bumping last time........

[contaminated]

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.

[bambino_32]

God Bless you Vusal
Thank you very Much!!!!!!
Yes It solved my issue Thanks again
You are genius!!!!!!!!!!!!!!)))))))))))))))))))))
rep+

[royUK]

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