Hello,
I have used a worksheet as a data entry screen. I want to allow only
certain entries in the first column so I perform a validation against a
pre-defined list within the 'Worksheet_Change' event. If the entry is
valid, this entry is used to fill in other cells with associated data.
However, I have run into the possibility that the user is copying a number
of rows from another worksheet and trying to paste them into mine. This is
something that I want them to be able to do. Unfortunately, when there is
more than one row being pasted, my code fails. Is there a way to recognize
that the user is pasting so that I might bypass the validation in this
instance and perform the validation later? Or, to see that the 'Target' in
the 'Worksheet_Change' event is more than one cell? If the answer is no to
both of these, would anyone have any other suggestions? I am open to all
possibilities. Thanks for your time.

--
Bob Holmes