Posted to microsoft.public.excel.programming

GS[_2_]

external usenet poster

Posts: 3,514

ByRef argument type mismatch (repost)

Properly converted...

Function TruncateString$(ByVal sText$, ByVal sFind$, Optional lStart& =
1)
If InStr(sText, sFind) 0 Then
TruncateString = Mid$(sText, lStart, InStr(sText, sFind) - lStart)
Else
TruncateString = sText
End If
End Function

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

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
"Compile Error: ByRef argument type mismatch" when calling my function from another module	ker_01	Excel Programming	2	August 14th 08 03:53 PM
ByRef Argument Type Mismatch	Sprinks	Excel Programming	5	August 8th 08 04:11 PM
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
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:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us