Thank you for your suggestion westconn. Your suggestion definitely helped. Once i changed the variable to a range object, i repeated the same process for two other necessary variables in my code and now it runs great. Does not throw the error anymore and allows me to handle the outcome a lot better. Thanks again! Any more tips on revising/improving my code?