Quote Originally Posted by spazem View Post
NewRow = Worksheets("input").Range("D12:BB12") - Runtime errer 13 - type mismatch error .
Sorry, it's a really simple fix, but I can't give you the answer until you comply with the request to re-title the thread. Instructions on how to do this are in Arlu1201's post.