VBA EXCEL LAST ROW INDEX ON ANOTHER WORKBOOK : This is part of a code i wrote under VBA Excel but it doesnt work 

what im trying to do is create a loop on a sheet of another workbook but the last row index line of code seems not be working

I hope to find a solution with your interactions

[PLEASE CLICK HERE TO FIND THE CODE][1]


  [1]: https://i.stack.imgur.com/F5jcy.png