It seems these issue affect different workbook at random. When he try to change formating in a workbook, would it be the cell color of font size, he receive a different error. Sometime, when this appear, part of the data he copied is pasted and other time no data is pasted.Īnother issue that seems to be linked with the first.
This issue doesn't appear if he try to copy/paste in the same workbook. When user is trying to copy/paste data from one Excel workbook to another, he receive the following error : So to prevent any frustation, I will post exactly what was done until now. It's also been quit a while that I'm working on this. That is not a weakness that is life.I'm currently working on an issue that a single user in my network is experiencing. "It is possible to commit no mistakes and still lose. This then caused the Clipboard to be wiped clean. That then briefly locked the clipboard, so the Paste/ PasteSpecial operation failed. I have come across a similar issue before, and it was been down to another program (in one case Skype) reacting to data being added to the Clipboard by "inspecting" it.
#MICROSOFT EXCEL CANNOT PASTE THE DATA CODE#
Not a pure fix, but this code will retry the Copy/Paste if it fails (up to 3 times), instead of just dropping it: Const MaxRetries AS Long = 3 Since the macro is functioning as expected, how can i troubleshoot what is causing the problem and make the error go away?Īs I said, I can't post the entire macro, but I can post some bits and pieces if anyone needs more info. If I were the only person using this, it would be a minor annoyance, but this document is used by many people that can't reliable be told to "just ignore" the error. What really confuses me is that if I select 'End' instead of 'Debug', the macro stops, but all the the sheets have had the picture pasted as well as the Export Macro assigned and everything works as expected. The Debug option highlights the line ws.Range("J62").PasteSpecial Ws.Shapes("Picture 1").OnAction = "Export" Sheets("EXAMPLE").Shapes("Picture 1").Copy If Not IsNumeric(Application.Match(ws.Name, nSheets,0)) Then ' seperate Macro called "Export" to the picture on each of these sheets. ' Copies the Picture from the EXAMPLE sheet to all worksheets not in the array and then assigns a NSheets = Array("EXAMPLE", "Weekly Totals", "Menu") ' Sets the non-generated worksheets as an array If I select 'Debug' it points me to a second macro which is called during the process of the generation macro' Sub CopyAllShapes() I recently made what I thought was a cosmetic change by moving the location of this picture, since then, when I run the macro I get an error: One thing that is copied is a picture (just a rectangle with the word 'Export' on it) that has a macro attached to it. To generate these worksheets, the macro makes copies of a worksheet fittingly named "EXAMPLE". I have a Macro that generates a number of worksheets based on the Month and Year input by the user (so "1" - "31" or "1" - "30" etc).
I have looked up the question and have seen several solutions addressing things like Select or having protected worksheets, none of which apply to me here.įor various reasons, I can't post the entire code, but I will give a description of what it does and post the exact sub that is giving me issues.
0 kommentar(er)
