Hello,
First of all, I have been looking quite a while in the other posts but I don't get why this code does not work
I am trying to copy matching cells from one sheet("CC") to another one (Sheet & n), it works but then I get 1004 Error.
When I first Activate my sheet and then paste, I don't get the error but this really slow down the code.
Please Login or Register to view this content.
Any idea ?
Thank you very much,
Jeremy
Last edited by Jeremycad; 10-19-2018 at 04:09 AM. Reason: title
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
serves no purpose.Please Login or Register to view this content.
Please Login or Register to view this content.
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.
Hello,
Thank you very much to both of you
Also to bakerman2, sorry if it was misleading but I will use n sheets in the future & also thank you for the code optimization
Have a great day,
Jeremy
Glad to help and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks