Run time error 6 - Macro that doesn't end

Hi All,

I have written the macro below which unfortunately keeps looping because of the way I have written it. The problem area is effectively the below code because everytime the file path is blank i have coded the macro to move onto the next line to locate a filepath until it finds another. The issue is that the loop never stops. Effectively I want the loop to stop after 66 trys. Any help would be greatly appreciated in fixing this problem.

Please Login or Register  to view this content.

Please Login or Register  to view this content.