Posted to microsoft.public.excel.programming

external usenet poster

Posts: 86

ByRef Argument Type Mismatch

Excel 2003 SP3, Windows XP 5.1 SP3

The following call is generating the subject error, highlighting intRow.
Can anyone explain it to me?

....Calling procedure
strTag = Trim(ActiveControl.Tag)
intRow = Int(strTag)
ActiveSheet.Shapes("R" & strTag) = _
Round(GetMeansResult(intRow, Val(ActiveSheet.Shapes("txt" &
strTag)), 0))

....GetMeansResult function

Function GetMeansResult(Index As Integer, X As Single)

Thank you.

Sprinks

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 04:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us