Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Keep getting Run-time error '5': Invalid procedure call or argument.
The line of code is: x=(y/C)^0.5 Tried to change x to x1 still same error. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
One of the values appear to be outside what the computer can calculate. When
you get the error, select debug and hover the cursor ober each of the variables y and c and see if you can read their values. Also what have you got them declared as in the Dim statement? Try Dim x As Double Dim y As Double Dim c As Double and see if that makes a difference. -- Regards, OssieMac "Philosophaie" wrote: Keep getting Run-time error '5': Invalid procedure call or argument. The line of code is: x=(y/C)^0.5 Tried to change x to x1 still same error. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I suspect you have a X or Y defined as something other than a variable. Make
sure you don't have a function or sub call X, Y , or C. "Philosophaie" wrote: Keep getting Run-time error '5': Invalid procedure call or argument. The line of code is: x=(y/C)^0.5 Tried to change x to x1 still same error. |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is the value of (y/C) positive? if it is negative, this error could occur.
Keiji Philosophaie wrote: Keep getting Run-time error '5': Invalid procedure call or argument. The line of code is: x=(y/C)^0.5 Tried to change x to x1 still same error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CreatePivotTable: Invalid procedure call or argument | Excel Programming | |||
Invalid procedure call or argument | Excel Programming | |||
Invalid procedure call or argument | Excel Programming | |||
Invalid Procedure Call Or Argument with VBScript | Excel Programming | |||
Invalid Procedure call or argument | Excel Programming |