|Workbooks don't have rows.|
Workbooks have worksheets. Worksheets have rows.
Therefore, there's not really such a thing as the "last used row in Workbook 2".
Please clarify what it is that you are trying to do.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.