Auto run macro from paste or paste special in to specific cell

[Craig Muir]

Hi All,

I have a macro that will run automatically if a specific cell value changes but it only works if you type the new value in to the cell, not if you paste or paste special the new value. Anyone know a way around this?
I’ve tried creating a few auto run macros to test this and they all work when you enter the value into the cell by typing but not from a paste or paste special…

Thanks,

Craig...

[Rupeshpatil]

Hii Craig

This might help you,It works good with me.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Row = 3 And Target.Column = 2 Then



End if
end sub

Rupesh

[Craig Muir]

Hi Rupesh
Not sure i'm getting what you mean by that one; can you explain further?

this is the code i'm working with as a sample:

Please Login or Register  to view this content.

Thanks

[Rupeshpatil]

better if you can send me the file in which macro is recorded

rupesh

[Craig Muir]

Hi Rupesh,

No can do I'm afraid, it's a work document with customer data in it. I'm just trying to add in a quick look-up capability for anyone using the sheet.

Sorry,

craig...