I have a column with letters and numbers. ex: REJ0001, REJ0002, REJ0003...REJ10935. The next line needs to be REJ10936. I would like to have VBA code to look at the range in (Table1) column (REJECT NO.) and determine the highest value and then add one to it. This should be done when USERFORM1 is opened.

I can then insert the new number into a new row with all other fields in USERFORM1.