+ Reply to Thread
Results 1 to 2 of 2

Force Paste Special Value under certain circumstances

Hybrid View

  1. #1
    Registered User
    Join Date
    10-18-2010
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    73

    Force Paste Special Value under certain circumstances

    When someone pastes, is it possible for Excel to automatically paste as "special values" only if the user is pasting data starting in column B?

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Force Paste Special Value under certain circumstances

    Yes you can with the event handler but I would ask why you want to do that as it might be easier to fix whatever is bombing instead of handling the paste.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mcros conflict, Force Paste Special
    By Ralem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2014, 01:34 AM
  2. Force Paste Special --> Values in a worksheet
    By vofstein in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-08-2013, 01:29 PM
  3. force paste comands to paste>special>values
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-08-2013, 09:04 AM
  4. A way to force paste special values
    By pdauction in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2011, 06:39 AM
  5. Force Paste Special Only
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2010, 03:55 PM

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