If it helps, we're using Excel 2010.
We have software in our office that creates Excel reports as output. The reports are a mess. Data all over the place, no table format, merged cells everywhere, etc. To create usable data, I wrote a macro for end users to import the report daily. They open the report, copy columns A:V, then run the macro while those columns are in the clipboard.
The macro has this line of code to Paste > Special > Values:
This works for everyone that uses it but one person, who gets a run-time error 1004, PasteSpecial method of Range class failed. I tried to manually paste > special > values, and it is not available. The paste > special options are:VB:Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Link to screen capture
From what's available here, it looks like she's copying a picture. This feels like some sort of security option, but I can't figure it out. Any suggestions?
Last edited by jronaldlee; September 17th, 2012 at 22:35. Reason: Added clear screen capture
In the macro, why don't you add a line
you know... instead of asking the users to copy.VB:range("A:V").copy sheets("xyz").range("A1").pastespecial xlvalues
You are correct. The image for paste special is either for an image/chart or other special data.
This is solved.
In my office, Excel 2010 was installed with the Bluetooth Add In installed by default. I took it off her computer, and the values now copy properly.
This doesn't make a lot of sense to me... I have other users who have the Bluetooth Add In, and no one else is experiencing the issue, but when I deactivated it, the macro started working properly. Posting my results in case someone else has a similar issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)