G'day gipsyfkls14,

To keep inline with forum rules if your original post issue (according to title of the thread) is completed please mark it "Solved". Then start a new thread with the issue you have presented in post #3 of this thread. This will have many benefits to you and future users of this forum.

Please note that I have a suggestion for your rows error but I myself still have the learners driver plate on for when giving advice on vba.

If you do need any help and you do start a new thread feel free to PM me the url in case I overlook the thread.