You sure that the worksheet_change event doesn't fire when you paste into a
cell?

OssieMac wrote:

I assume that you are using a Worksheet Change event. This does not work when
something is pasted to a cell and I assume that changes created by a dropdown
is the same as pasting.

Regards,

OssieMac

"Jensan" wrote:

Hi all,

I am trying to use a simple VBA program to delete a row when the value of a
cell changed. A drop-down list is provided to the cell.

The function was working, but after some changes now it isn't. No error
message is returned. However, when i tried to change the value by typing, it
works. Also I have tried to create another dummy list for testing, and it
also doesn't work. The delete function just gives no response.

Could anyone advise what change would do something like this?

Thank you.

Jensan

--

Dave Peterson