Rich,

If Target is more than one cell, you have to trap that (Target.Count 1),
and process each cell in that range

For Each cell In Target
'etc
Next cell

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rich Wallace" wrote in
message ...
Hi all,

I am running some code against the Worksheet_Change event that picks out
the
target.value and writes the output to XML. What I've noticed lately is,
if/when a user performs a copy from one cell, and pastes the value to
another cell or a range of cells, my Worksheet_Change event fires, but
does
not trap the target.value from the first cell that is populated nor does
it
run for every cell that had new data pasted to it.

Can someone point me in the right direction to code for this? If they
paste
one value to five cells, I need to extract the new value from each
individual cell it was pasted to.

Thanks!
-Rich