Thanks p45cal!! There is no more error code after running the macro.

Also, Thanks SamT...You helped me a lot with your advised code.