Mar 20 2006, 07:39 AM
I want to be able to identify whether a user has pasted data into a worksheet or simply typed into a cell. The reason being I have validation that needs to reapplied to those cells that have been pasted over but i dont want to trigger the ApplyValidation subroutine if its not required.
I've looked at using the target address of the current range to detect this, if it returns a range rather than a single cell address then I am assuming a paste has occurred.
Or is their some way of only allowing a paste special with values only?
Mar 20 2006, 07:59 AM
I believe there is no event which lets you capture when a paste was done. One way would be to take away all usual paste possibilities (menus, right click, ctrl+v) and replace it with a custom button which does what you want and you could then determine if this routine was run or not.
Just a thought!
Mar 20 2006, 08:05 AM
Thanks for your help...I will give that some thought.
Mar 20 2006, 08:17 AM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here