I would suspect that the range name CurrentBal was not defined on sheet
Payable in workbook BofACheckRegister.xls in folder
C:\extrafiles\SecondaryLevel

Open it up and check using Insert Name Define

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup