Please don't use On Error for this. Use If statements to check the values putinto the cells and avoid the For loop if the values are bad.