I have the following code that worked fine for a few months. Recently at the ActiveSheet.Paste portion of the code I have been getting the error "Paste Method of Worksheet Class Failed". Does an anybody have any ideas what may have happened? Is there another string of code I can use as a substitue to ActiveSheet.paste?
Please Login or Register to view this content.
Last edited by rhudgins; 06-27-2011 at 03:57 PM.
Personally, I am better able to investigate problems in spreadsheets if I have a copy of the workbook to play with.
Has anything changed? New columns? Total rows? Data source? Number of worksheets? Have you got any hard coded ranges that have been exceeded?
Code doesn't suddenly stop working. Either something changed or there was an underlying problem that simply wasn't hit until recently.
Regards
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
Strangely it is working now. I will let you know if it stops again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks