Results 1 to 5 of 5

Thread: Trapping Copy To Range Before Copy/Cut Paste

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-04-2011, 10:44 PM #1
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    15

    Trapping Copy To Range Before Copy/Cut Paste

    How can I trap using VBA when a user copies i.e. a single cell into a range of say 20 cells. I am looking to trap what range the user copy to (not from) - I use data validation - but it seems the user can copy "invalid" values into my "secure/validated" cells.




    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 06-10-2023 at 04:25 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy/Paste Excel Range/Chart into Powerpoint VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 03-13-2014, 02:59 PM
  2. Macro Copy Columns and Paste in rows.
    By TommyKris in forum Excel Help
    Replies: 3
    Last Post: 03-06-2013, 02:36 PM
  3. Copy cells from Sheet2, paste to next blank row in Sheet1
    By marreco in forum Excel Help
    Replies: 2
    Last Post: 02-11-2013, 08:13 PM
  4. VBA -- Copy/Paste across sheets
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 09-21-2012, 02:07 PM
  5. Copy webpage and paste it as HTML into an excel sheet using vba
    By LalitPandey87 in forum Excel Help
    Replies: 2
    Last Post: 04-08-2012, 09:42 AM

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
  •  

Forum Rules