Posted to microsoft.public.excel.programming

Sprinks

external usenet poster

Posts: 86

ByRef Argument Type Mismatch

Thanks, Lars.

"Lars Uffmann" wrote:

Sprinks wrote:
Function GetMeansResult(Index As Integer, X As Single)

Change that to

Function GetMeansResult(ByVal Index As Integer, ByVal X As Single)

and you're fine.

It's an annoying and most idiotic behaviour of VB to automatically
assume (and demand) all parameters to a function or sub to be passed by
reference, unless defined as ByVal.

HTH,

Lars

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
ByRef Argument Type mismatch	Tone[_4_]	Excel Programming	4	July 3rd 08 02:35 PM
ByRef argument type mismatch when passing dictionary object	signon77	Excel Programming	7	January 8th 08 10:03 PM
HELP "ByRef Argument Type Mismatch"	RocketMan[_2_]	Excel Programming	6	June 7th 07 07:00 PM
"ByRef argument type mismatch" Error	Baapi[_4_]	Excel Programming	2	September 17th 05 12:47 AM
ByRef argument type mismatch error?	sermest	Excel Programming	4	June 17th 05 06:50 PM

All times are GMT +1. The time now is 12:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us