Complile Error: Type Mismatch ??? After adding error trap

[clemsoncooz]

So this was my code and it worked just fine.

Please Login or Register  to view this content.

I wanted to error trap for when the find command doesnt find anything - so I changed my code to this and now it doesnt work. I get an COMPLILE ERROR: TYPE MISMATCH. What does that mean?

Please Login or Register  to view this content.

All I changed was:

Please Login or Register  to view this content.

[shg]

You've declared the variable as a Long (an ordinary scalar variable type) but are comparing it to Nothing, which is reserved to object variables.

[clemsoncooz]

Thanks shg.

So how do I fix this?

Please excuse my ignorance. Still learning.

[shg]

Just guessing,

Please Login or Register  to view this content.

[clemsoncooz]

That I do believe is working perfectly!

Thank you!