Forum Discussion

wiens's avatar
wiens
Brass Contributor
Jun 23, 2025
Solved

Invalid procedure call or argument (VBA Error 5 Excel) in Build 19011.20000

Version 2507 (Build 19011.20000) gives the following VBA error in Excel: "Invalid procedure call or argument (Error 5)" It stops at the following line in VBA: === qv_wiel = WorksheetFunction.Min(3...
excel
Formulas and Functions
Macros and VBA
office 365
  • wiens's avatar
    wiens
    Jun 30, 2025

    This bug has been resolved. I have done a clean installation of Windows and Office.

wiens's avatar
wiens
Brass Contributor
Jun 24, 2025

I have traced the error back to the source in a smaller formula. The following code has been added in the macro in the file.

 

===

Sub test()

x_wiel = 0

x0 = 0

y_wiel = 0

y0 = 1

f = (x_wiel - x0) ^ 2 + (y_wiel - y0) ^ 2

MsgBox SQR(f)

 

End Sub

===

 

 

This is not correct, f is not -1 but f is actually +1. The square root of a negative number gives the VBA error 5. This is now a major calculation error in Excel.

 

 

 

 

  • wiens's avatar
    wiens
    Brass Contributor
    Jun 30, 2025

    This bug has been resolved. I have done a clean installation of Windows and Office.

    • wiens's avatar
      wiens
      Brass Contributor
      Jul 11, 2025

      This problem has been solved in build Windows 11 Insider Preview 27898.1000: "Fixed an underlying issue in the previous flight, which could lead to Math.Pow() not outputting the correct result, which could lead to unexpected behavior in apps and games."

Resources