Get Error/Debug because average's worksheet function

  • I want to average a range of MSE but I get a debug message "Method 'Range' of Object ' _Global' failed.


    these are my code and i've got debug on

    MeanMSEMod = Application.WorksheetFunction.Average(Range(MSEMod))

    StdDevMSEMod = Application.WorksheetFunction.StDev(Range(MSEMod))

  • amde10

    Changed the title of the thread from “Application.WorksheetFunction.Average Get Error/Debug” to “Get Error/Debug because average's worksheet function”.