Solve ignore error in excel

@fairymemay - I am not sure how to proceed here …I gave 2 working codes …

If invoke vba is throwing error …please try the other method.