Hi,
I'm getting the following error with the code shown below: PasteSpecial method of Worksheet class failed
I am getting error on the last line of the codeWas wondering whether anyone could help? Seems a simple fix and will help me with vba in the future
Please Login or Register to view this content.
Thank youPlease Login or Register to view this content.
Please Login or Register to view this content.
Hello danfullwood,
You may also try:
Regards.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Thank you both, each of yours worked. Winon, i just had to include the line where it moves to the end column on yours but otherwise brilliant
Hi danfullwood,
You are welcome.
Thank you for the feedback, and appreciation.
Regards.
Hello danfullwood,
Then maybe you would like this better?...Winon, i just had to include the line where it moves to the end column ...
Regards.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks