Code working when using F8, but doesnt work properly through button click.

Okay, so I have a code that works perfectly when I go into Vb and run it manually.

I have this code linked to a button, and the button click sub calls these two subs which are in separate modules.

When I click the button on the worksheet, it does not result in the same thing.

I have attached my workbook. The button I am using is located on "ClaimsKL" and it is called "Modify data" (ModifyBTN)


When running the code through F8, it is supposed to delete all rows that contain "#N/A or """ in the F column, and it does this perfectly. BUT, when I press the modify button, it does not delete these rows, it simply removes the "#N/A" and replaces it with "".

Please Help!