The code above adds an autonumber from a form. However, I occasionally get a "Run-time error '13': Type mismatch" If I navigate away from the sheet this code refers to and then go back to it. As if it's not looking at the previous number and adding another.Please Login or Register to view this content.
Can anyone see an issue with this bit of code or suggest another bit of code that will add an auto number by checking the previous number regardless of where I am in the workbook?
Hope that makes sense.
Bookmarks