Worksheet_Change help

[wrightyrx7]

Hi all,

I have a workbook that I have used for a while where I put a number in 'col A' and it does a vlookup for other details.

I had a problem where if I DELETED more than one number from 'col A', I got an error from the macro. I got around this with:-

If Target.Cells.Count > 1 Then
    Exit Sub
End If

But now I want to ADD more than one number at a time and the vlookup to run. But im guessing the about code will stop this happening.

Is there any suggestions to how i will get around this?

Thanks in advance
Chris

 

[wrightyrx7]

Thank you both sooooo much.. that was mind boggling for me trying to figure it out.

And now I will hopefully remember for future reference :D

Thanks again

Chris

 

[ParamRay]

.
.

Ah, yes. I missed that one.

Thanks to FormR and RoryA for clearing that up...