Please use code tags around your code as it makes it easier to read.
I am thinking that the code is in a workbook named TEST - QUOTE SHEET.xlsm. If so, change all the lines with:
to
Windows("TEST - QUOTE SHEET.xlsm").Activate
Now having said that, this code should be cleaned up. You don't need to activate workbooks back and forth. If this is of interest to you, then you can start a new thread asking for help on cleaning up the code and making it more efficient.ThisWorkbook.Activate
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Thank you, I will make the change and see if that corrects my problem. I'm sorry, but I don't know what code tags are. I am self taught and know just enough to be dangerous. I appreciate your help and I will submit another thread to clean up the code. Thanks a million.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks