Hi there, I'm stuck at a place where I'm not able to paste the data under the last row. This code used to work perfectly fine in the beginning. But now it copies all the columns and when tries to paste throws the error.
I have already raised a same request in the below forum
Please Login or Register to view this content.
https://www.mrexcel.com/board/thread...error.1206892/
Please help me with this.
Thank you.
Last edited by Manoj Gaidhankar; 06-09-2022 at 01:09 PM.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
What is the error number and error message?
The issue has been fixed as there were few hidden files due to which data was incorrectly copied and also there was an internal error due to which it happened. Thank you for your interest.
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks