Beginner If Then Help

Hi. I'm new to the boards and would like to see about getting some help.

I'm writing a script to auto number a series of worksheets in the form of "Page xx of yy". Where xx is the current page and yy is the total number of pages. I have 2 main scripts doing this. My first script which is run as an addon is:

Please Login or Register  to view this content.

This works perfectly. My problem is in my script I use to select the proper cells. I have a check to be sure that the cells entered are actually cells. If they are not, it tells the user to make the corrections. If the cell is inserted incorrectly, the sub-routine runs through again, BUT, it goes back to the If Then statement where the error occurred and gives the user error again, even if the cells were entered correctly. I'm checking that the first character is a letter and the second character is a number. The Code I used for this is:

Please Login or Register  to view this content.

Yes, I know it's ugly, but I'm still learning how to program so I'm pretty much fudging my way through it. I have a few parts of the script disabled, as I was trying a few things, but nothing was working.

Any help as to how to fix my program will be greatly appreciated.

Try something like this...

Please Login or Register  to view this content.

Ok, I like that. It looks that you are exiting the sub on an error instead of having the user re-enter the information into the form. That will fix my problem. I was just trying to avoid exiting the sub on an error.
Thank you for the help.

You're welcome. The user could not reenter the data while the sub is running.

Ok, That's probably where my error was coming from. I was trying to have them re-enter the data without exiting and restarting the sub.
Thanks again.