Your assumption is incorrect.

The change event fires whether on cell or many.

The reason the code is there is to stop processing if there are multiple
cells.

You even validate that the event fires with multiple cells in your
statement.

Since your link doesn't work for me, I can't advise on how to change the
code or why you would get the cited error.

--
Regards,
Tom Ogilvy

"noddy26 " wrote in message
...
Yes. If I take that out, I still encounter the error msg box at the end
of the code "you have not entered a valid number"

I think that IF statement is there because the worksheet_change event
only occurs when a single cell is edited and not a range. Perhaps I
could loop the range somehow but I"m not sure how to do that.


---
Message posted from http://www.ExcelForum.com/