You'll get a Type MisMatch, error 13, if you put a non-numeric character on column E.
Maybe this:
Proper indenting and some "white space" will make it easier to read and check that all the blocks are started and ended correctly.
As has been suggested, On Error Resume Next will cater for the non-numeric entry in column E.
Commenting out the "cell" on "Next cell" has no effect. It is my understanding that the Next does not require a parameter and it is, I believe, more efficient to leave the parameter/variable out. However, for clarity, it is good practice to leave it there and comment it out rather than simply remove it.
Regards, TMS
Bookmarks