Hi,

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?

Thanks,

Simon.

Hi,
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!
HTH
Good luck

Thanks for your help...I will give that some thought.

Cheers,

Simon.

You're welcome!
Good luck!