Error On VBA code on same procedure

You could use (just before the line which throws the error):

Please Login or Register  to view this content.

which makes the code just carry on to the next line
and then insert immediately below the line in the code that throws an error (ie after trying to find the file):

Please Login or Register  to view this content.

(which cancels it again)

Be very careful when you use this - it is not always appropriate!

Do you understand why you getting the error?
- does the file not exist?
- are there illegal characters in the attempted file name?

Is it macro "Partner" in workbook Master_Account that is throwing the error?
Which line in the macro is giving you the error?

thanks

Please find the error line

For some reason there is a problem in Excel sometimes with xlFilterCopy - it just refuses to work. I tried setting ranges using variables but that did not work either.
Your code is correct but it does not run. So this is a workaround.

Method:
- replace xlFilterCopy with xlFilterInPlace
- replace columnV with specified range (code runs faster)
- after filtering copy columnV values and paste to columnAA
- remove the filter

So to make it work, try the following
REPLACE

Please Login or Register  to view this content.

WITH

Please Login or Register  to view this content.

NOTE - the code would work using .columns("V:V") but runs much slower

If your problem is solved, please mark thread as solved (go to ThreadTools at top of thread)