Unable to reset back to counting from C2 after clearing contents

  • Hi, all.

    I have created a list where a tech claims x amount of account numbers, and his/her name is populated in the first blank cell in row c.

    My code works, but I cannot reset back to C2 once the form is cleared. I clear all of the data from the sheet, but the code will give me an error unless there is data in the very last populated cell before I cleared it. Here's my code.
    How can I clear the sheet and start fresh? IT's as if I need to reset a count, but I have no idea what to do

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!