Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default Invalid procedure call or argument

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,510
Default Invalid procedure call or argument

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default Invalid procedure call or argument

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 199
Default Invalid procedure call or argument

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CreatePivotTable: Invalid procedure call or argument DesertCyclist Excel Programming 4 October 15th 10 03:53 PM
Invalid procedure call or argument salgud Excel Programming 1 January 12th 09 10:41 PM
Invalid procedure call or argument JE McGimpsey Excel Programming 0 January 12th 09 09:38 PM
Invalid Procedure Call Or Argument with VBScript [email protected] Excel Programming 0 November 28th 07 01:50 PM
Invalid Procedure call or argument T De Villiers[_58_] Excel Programming 1 July 25th 06 03:01 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"