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!

What do you expect to be the last line in your data, The First code line below (Part of you Code), Returns 224 where the next line returns 297 , which is actually the last line in the sheet.
Which is correct ???
Could this be a problem ???

Please Login or Register  to view this content.

thanks joseph!

should I get rid of the "On error resume next?"

MickG,

it should be returning 224 if it is working correctly.
If it is returning 297, it has not deleted the rows that it needs to delete

Thanks so much!
I can always count on you!!

Sorry I see it was another (Not the active) sheet it referred to. !!!!