View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Functions 101 The basics

"Martin Fishlock" wrote in message
...

certain cicrmustances more than one variable is returned and then you
need to use globals or byref (like pointers in c(++)) so I could write a
function

function splitinhalf(byval s as string, byref s1 as string, byref s2 as
string) as boolean

and this function whould split the string s in half and put the answers in
s1 and s2 and return true on success and false otherwise.



or the function could return an array