Run-time error '1004' HELP!

[Decoderman]

Hello all,

I have been banging my head against the wall trying to figure out why I am getting this error. I have checked to make sure the data types are the same in the cells and have been looking all over the internet to try and find some clue, but to no avail. ANY direction would be helpful! I turned the text red where it is giving me the Run-time error '1004': Unable to get the Find property of the worksheetfunction class.

Please Login or Register  to view this content.

[StephenR]

Sounds like it's not finding mytable in searchtable.

[Decoderman]

Yes. That is correct. But shouldn't the "On Error GoTo FixIt" account for that? It Instead throws up a Error Message.

[StephenR]

Try

Please Login or Register  to view this content.

[Decoderman]

Stephen. You are a genius. That worked great!

Might I ask why/what is different about that code?

I like that it worked but would really like to understand why it worked.

[StephenR]

Well one, you need to check whether it's a number first rather than >0 because if it doesn't find it, you are asking if an error >0 which rubs Excel up the wrong way. For the difference between using application as opposed to worksheetfunction, this man explains it better than I could (error handling section is most pertinent here):

http://www.cpearson.com/excel/callin...ionsinvba.aspx

[Decoderman]

Thanks a lot of the helpful tips!