I have a workbook in which I can add initials or delete them ( in the 'Teachers' column - column C). It actually works fine.
The initials are numbered, in the next column (D). No header.
I can delete initials in column C. The numbers will adjust accordingly in Colum D.
The limit on the initials entered is 20 (in column C).
I can delete in Column C, ANYWHERE, just by clicking on it, any initial.
HOWEVER, If I delete the FIRST initial in C3 (number 1 in column D), vba acts up!
Please help me to fix it.