VLOOKUP Causing Error 13 with Macro

[simeonmein]

Hi All
I Have a Macro that determines if a cell has a value, if not, It must tell the user to add the values. All is well and it works well, but I had to add "Exit Sub" to stop the Macro from continuing because of the nature of the code that follows. Now, even if The cells are populated, the code stops at the "Exit Sub". Here is my code:

Please Login or Register  to view this content.

I have tied adding a "Else If" statement to try and continue the code, but it does not except it and marks the code in Red. What should I do, It's like I'm damned if I do and damned if I don't.
At the same time, I have a columb with a VLOOKUP formula(=IFERROR(VLOOKUP(@[Columb1]PartsList!A5:I10000,2,FALSE),0)) that gives me a error on the same code If I choose to change the value of the cell, How do I get past that also? The value in the cell gets it value from another sheet depending what Item I choose, but I have a item that does not have a value so that I may enter my own value, but my code stops with a error 13. Any Help would be great.

Thank you in advance.

[mehmetcik]

You Error is two line before that.

Please Login or Register  to view this content.

Should be

Please Login or Register  to view this content.

[simeonmein]

Thank you, That solved my issue.