hi, i have 2 macros that run fine by themselves, but when I try to combine them into one i get a "run-time error '1004' application-defined or object defined error" and don't know why. the error is in the SetupVariables macro at the line listed below, but it works fine in other macros since it is used to set up the variables. any ideas why i am getting this error?

Sub RunBiWeeklyTest()

Application.ScreenUpdating = False
Application.DisplayAlerts = False

    ChDir ActiveWorkbook.Path
    Call SetupVariables
    
    Workbooks.Open Filename:=ActiveWorkbook.Path & "\" & todays_run, UpdateLinks:=0
    
    Call LoadEOOC       ' load bi-weekly validation
    Call LoadValidation
 
Application.ScreenUpdating = True
Application.DisplayAlerts = True

End Sub
the daily_file assignment is flagged in the SetupVariables macro (below), but not the first assignment line for the business plan. if i comment out that daily_run line it flags the next eligibility_file line.

Sub SetupVariables

    business_plan = Worksheets("inputs").Range("business_plan").Value
    daily_run = Worksheets("inputs").Range("daily_run").Value               ' error here
    eligibility_file = Worksheets("inputs").Range("eligibility_file").Value

End Sub