Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 5 of 5

Thread: Unable to Paste > Special > Values?

  1. #1

    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:
    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 Images Attached Images
    Last edited by jronaldlee; September 17th, 2012 at 21:35. Reason: Added clear screen capture

  2. #2

    Re: Unable to Paste > Special > Values?

    If it helps, we're using Excel 2010.

  3. #3
    Join Date
    30th August 2012

    Re: Unable to Paste > Special > Values?

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

    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.

    Excel Video Tutorials / Excel Dashboards Reports

  4. #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.

  5. #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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. VBA: Paste Special (Values)
    By VBAnewbie in forum Excel General
    Replies: 5
    Last Post: May 12th, 2012, 07:17
  2. Paste Special Values
    By LJones79 in forum Excel General
    Replies: 3
    Last Post: April 7th, 2012, 08:26
  3. Paste Special Values
    By junll in forum Excel General
    Replies: 8
    Last Post: April 24th, 2007, 11:04
  4. paste special values
    By ZeroMan001 in forum Excel General
    Replies: 3
    Last Post: February 7th, 2006, 07:44
  5. paste Special Values.
    By countryfan_nt in forum Excel General
    Replies: 3
    Last Post: September 17th, 2005, 19:40


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts