Hi there,
Did you accidentally copied only part of the code that was actually working? Since the one you provided is not complete.
Anyway, to skip one cell in your sheet, you can add a string as shown in the picture below. Remember to replace the cell $A$2 with the actual cell to skip in your sheet.
If you have any further questions, please don't hesitate to ask me.
Amanda