Hello,
I have the following code which has been working for years. The tab it runs on (using a button via insert shape) is debugging at ActiveSheet.Paste. Any suggestions? I have even rerecorded a macro following the same steps and can't seem to figure out why it is failing. I don't believe the clipboard is being cleared in the code for it to fail. Thanks in advance.
Please Login or Register to view this content.
what code error are you receiving on that line of code?
run-time error '57121'
Application-defined or object-defined error
Maybe:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You are awesome JBeaucaire. Thank you. What is crazy is that code ALWAYS worked before and suddenly doesn't. We have been having some issues here...some people are on 2010 excel and those of us that do more advanced stuff have 2013 (64Bit). Not sure if that is causing some issues or if it is related to a patch. Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks