WorksheetFunction within macro

[bstubbs]

Howdy, folks:

I need some ideas. I'm using the attached code and keep getting error '1004' pointing at the "application" statement. The vlookup function works fine within the worksheet. What am I doing wrong?

Please Login or Register  to view this content.

TIA.

Bob

[royUK]

Why not use the >Find method in VBA? Take a look at the VBA Help files for Find, the explanation & example code is quite good.

Without knowing what your variables are it is hard to say what is causing the error

[TimK]

I think you are using 'routeName' both as the name of a variable to be returned and of the range/table to be searched.
Change one or the other and see if that works.