You should not mixup Range and a single Cell, since a range may consist of
several cells and subranges.

Hope i didn't confused you to much


Greetings Jonjo

"xlcharlie" wrote:

I am using a change event to call a macro when any field in a specified
column is changed. The code appears below. Generally, only one cell at a
time will be changed, but in the even the user changes multiple cells at once
(e.g. pastes values) this code does not work because the target is a range
rather than a single cell. Can anyone help me to adapt the code to handle a
range rather than a single cell? Thanks much in advance.