Claimskl contains the button Modify Data. and in the sub modifyBTN_click() it calls the sub test. which is the code that you have written.

and once the button is pressed, it deletes the first row, and it doesn't remove the #N/A or blank entries.

When you say, "Re-run both codes" how are you running them?