Hello,
I have a small VBA macro which generates a unique employee ID based on whether they are full employees, from temp agency A and temp Agency b. I have attached a sample spreadsheet showing what I have thus far. The code is as follows...
Currently I can create a new row at the bottom of the table with no error. However when I attempt to insert a new row in the middle of the table, my VBA throws runtime error: 1004. Please assist me troubleshooting this problem as I am extremely new to VBA.
Thank you in advance.
Bookmarks