Personally, I'd go with Dan's idea, the Is Nothing, that's what you should use. You don't need to use the expensive On Error Resume Next. You need to be extremely careful with that, it will be hard to tell what error you are getting (especially in debugging your code). It makes a good catchall but should be used carefully.