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

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

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