Error Type 13 when running a macro

I have a workbook("Adherence Macro") that I created and when i move it from the folder where I created it, it throws the error "Run-time error '13': Type mismatch. I have included my workbook and the code to see if anyone can assist! Thank you very much in advance!

Please Login or Register  to view this content.

This is where it is throwing the error:

Please Login or Register  to view this content.

Basically this is supposed to import data from my agents sheets which each one has their own workbook as their name - like I stated when the workbook was where I created it, the macro ran fine and didnt have any problems, but once I move the file to a different folder that is when I start having trouble.

Well they are still in the same folder, I just moved that folder to a new area and that is when it throws the error. I change LR as Long to LR as Variant and it puts the error down to the line

Please Login or Register  to view this content.

Column A starts with row 9 with dates in them - do you know what will need to change for that to happen correctly?

I have updated the code to this:

Please Login or Register  to view this content.

I am showing that myMax = 1 & LR = 0 which is still throwing the error on this line:

Please Login or Register  to view this content.

Any help would be greatly appreciated! I have also included a sample workbook of my "Adherence Macro" workbook & one of the agents workbook "Eva Yates" to help you better understand!

Originally Posted by Jamesraywebber85

I have updated the code to this:

https://www.excelforum.com/excel-pro...ml#post4898038

Based off what I found is there an error in the way the LR is written. See example of what I found to further assist & as always thank you in advance for all your help!

This is where the person was getting an error in this code:

Please Login or Register  to view this content.

This is the solution to fix the error (mismatch 13)

Please Login or Register  to view this content.

Any ideas?