Announcement

Collapse
No announcement yet.

Unable to Paste > Special > Values?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unable to Paste > Special > Values?

    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:
    Code:
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    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:

    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?
    Attached Files
    Last edited by jronaldlee; September 17th, 2012, 21:35. Reason: Added clear screen capture
    find me here or on my photo blog.

  • #2
    Re: Unable to Paste > Special > Values?

    If it helps, we're using Excel 2010.
    find me here or on my photo blog.

    Comment


    • #3
      Re: Unable to Paste > Special > Values?

      In the macro, why don't you add a line

      Code:
      range("A:V").copy
      sheets("xyz").range("A1").pastespecial xlvalues
      you know... instead of asking the users to copy.
      You are correct. The image for paste special is either for an image/chart or other special data.

      Comment


      • #4
        Re: Unable to Paste > Special > Values?

        The name of the file we are copying from varies - the software that generates that Excel file does not give it a consistent name, so that part is done manually by the end user.
        find me here or on my photo blog.

        Comment


        • #5
          Re: Unable to Paste > Special > Values?

          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.
          find me here or on my photo blog.

          Comment

          Working...
          X