I have the following code which I am trying to copy data from sheet "Data" and pasting the data on specific sheets based onthe names in Col A. This must be pasted after the last row containing data on those sheets
I get a run time error "copy method of range class failed" and the code below is highlighted
Please Login or Register to view this content.
It would be appreciated if someone could kindly amend my code
This should be because A1 is already the top cell so you can't go up anymore.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.
Thanks for your help
I amended the code as folows:
Please Login or Register to view this content.
When Running the macro, I get compile error : syntax eror
Please check & advise
My bad.Remove double quotes after
Please Login or Register to view this content.
Thanks for pointing out the problem. I should have picked this up
Thanks for all your help
on testing the macro, it clears the data onnthe source sheet
Please check macro as this should not be happening
Your post does not comply with Rule 8 of our Forum RULES.
Do not crosspost your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
HTH
Regards, Jeff
My apologies Jeff . I inavertently forgot to post the link
https://www.mrexcel.com/forum/excel-...heet-name.html
Where did this line go ????
Please Login or Register to view this content.
I removed it as I did not think that it was necessary
Well, now you know it is.
PS: Thanks for rep+.
I do thanks. I learn something new every day from guys like yourself as well as the many excel forum experts who voluntarily give up their time to help others like myself. I certainly appreciate the help I get, which has improved my Excel skills tremendously
You're more then welcome. Keep leraning.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks