The following code i have is bringing an error as been out of range;

'Using the most recent mapping file, copy data from "Hiport Nominals" & "Funds" into the "Mappings" sheet'
    
    lrow = Workbooks(FName).Worksheets("Hiport Nominals").Range("A" & Rows.Count).End(xlUp).Row
    Workbooks(FName).Worksheets("Hiport Nominals").Range("A1:AI" & lrow).Copy ThisWorkbook.Worksheets("Mappings - Nominals").Range("A1")
    Application.CutCopyMode = False
    lrow = Workbooks(FName).Worksheets("Funds").Range("A" & Rows.Count).End(xlUp).Row
    Workbooks(FName).Worksheets("Funds").Range("A1:AG" & lrow).Copy ThisWorkbook.Worksheets("Mappings - Funds").Range("A1")
    Application.CutCopyMode = False
    Workbooks(FName).Close False
What i'm trying to do is open a file, copy data from 2 tabs in that file over onto 2 tabs in a new file where the macro is run from?

Any ideas what is going wrong