Hi
I have a piece of code that's worked for a long time but has decided to stop recently.
Does anyone know what may be causing this?
ThanksPlease Login or Register to view this content.
Jo
Hi
I have a piece of code that's worked for a long time but has decided to stop recently.
Does anyone know what may be causing this?
ThanksPlease Login or Register to view this content.
Jo
Hi Jo2710,
That error message is usually the result of the code not finding the exact sheet name it's been told to find. So at a guess I'd say there's no tab called "QuoteTracker" (note there's no space as in the current workbook) in the workbook the code is trying to paste into.
HTH
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Hi Robert
Thanks for your quick response. The sheets are both definitely there and I've tried with the naming convention Sheet1 also but still no luck. It's making me pull my hair out!!
Thanks
Jo
Not sure as it works for me
Post the code you're using to both define and set your two workbook variables.
This is the whole piece of code:
Please Login or Register to view this content.
I figured it out, I feel stupid now! Some had renamed the sheet and corrected it but put a space after so I hadn't picked it up!
Thanks so much for your time
OK - no problem. I'll post this anyway as you might find it useful as it will work as long as "Quote" is part of the sheet name:
Regards,Please Login or Register to view this content.
Robert
And to avoid the repetition of sheetnames.
Please Login or Register to view this content.
Last edited by bakerman2; 06-13-2016 at 11:32 PM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks