Skip blank rows in VBA Vlookup

[PaulM100]

I am looking for a way to skip the blank rows in a range. My code:

Please Login or Register  to view this content.

in this range rw = 14 To 170, I wanna skip any blank rows and move to the next. It is supposed to search the value in column C in another file.
Any ideas on how to do this?

[rorya]

Do you mean this:

Please Login or Register  to view this content.

[armando12345]

Would adding something like

Please Login or Register  to view this content.

after the "For" not fix it?

Edit: Posted as the user above me was positing. Something along the lines of their solution.

[PaulM100]

Thank you rorya, fixed my issue. One more question. Is it possible to wrap an application.vlookup in a IFERROR formula?

[rorya]

Yes, although indirectly. And since you're looking up the same value both times, you should just do that once:

Please Login or Register  to view this content.

[PaulM100]

Great stuff rorya. Thank you very much!

[rorya]

Glad to help.