before you compare check for nothingness. As the Find method may not find what you are looking for and thus be "nothing", in that case you should not compare it to anything (it appears that you took out that line, but you need it so it will only copy what you want). Before you do that, you must make sure Rng has something, meaning it found a value in the range.

If Rng Is Nothing Then