+ Reply to Thread
Results 1 to 5 of 5

Why am I losing my paste special menu????

Hybrid View

  1. #1
    Registered User
    Join Date
    03-31-2012
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2007 and 10
    Posts
    2

    Why am I losing my paste special menu????

    This is happening in both 2007 and 2010. I am trying to record a simple macro that involves the NOW() function. But after the NOW() executes I need to replace the cell's contents simply with the values the program produces. Easy right? Just go to "paste special" and choose "Values." Nope. Tried it in Excel 2007 and 2010, and instead I get this weird menu that I am not familiar with that gives me an option of pasting in text or uniform or unicode text or something. I am working with a textbook and this is happening in direct contradiction to what the textbook says should be happening. Is there some setting I am missing? Why won't my normal paste special menu come up??? Any master out there that can help me would have my sincerest thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Why am I losing my paste special menu????

    In the following example, A1 has the '=Now()' function.


    Sub Macro1()
    '
    ' Macro1 Macro
    '
    
    '
        Range("A1").Select
        Selection.Copy
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    End Sub

  3. #3
    Registered User
    Join Date
    03-31-2012
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2007 and 10
    Posts
    2

    Re: Why am I losing my paste special menu????

    That may have just been me skipping over the name part to try and examine the "meat" of the problem. The real question is where is the paste values option and how do I get it back? I'm at an impass here. I felt like this was too simple of a question for the VBA area.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Why am I losing my paste special menu????

    Problem seems to be related to Skype. it doesn't need VBA to fix.

    See this
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Why am I losing my paste special menu????

    Have you read the link? Have you got the Skype plugin installed, if you have uninstall it

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1