macro crashes and will not restart if value not found is added

Hello

I am having an issue where the following code comes to an error code rather than completing the sub if a value is added that cannot be found in column 2.
the issue looks like it is coming from the move.select on line 11, but without this line the if function that decides whether or not to add a line does not work.

Please Login or Register  to view this content.

Hello, sorry I might be missing the point but I do not see how this fixes my issue. with your proposed solution It gets rid of the full value meaning that the if function does not function at all.

I tried the formula you suggested but it now has the same issue as if I did not have the move.select in that it will only run the insert line portion of the code and will not react correctly if the cell is blank

Please Login or Register  to view this content.

Thank you so much, this worked brilliantly, I didn't know move was a variable, I am relatively new to VBA

Originally Posted by BaronVonBeefDip

... I didn't know move was a variable, I am relatively new to VBA

... "you learn something new every day" ...

I have recently noticed that the frequently used variable name "rng/Rng" (for some range (-s): Dim rng As Range, Dim Rng As Range, etc.), is in fact the property name of the "Sort" object (Sort.Rng property) ... "many of us" make this "mistake".
... so, "everybody learn something new every day" ... and ... so be it ...