It should be

msgbox functionname(range("a1:a10"))


What hapopens when you do that? Can it handle multiple cells?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Mike Archer" wrote in message
...
What are you supposed to pass to a function that has a parameter "range"
data
type? I have tried the following:
msgbox functionname(range("a1:a10").address)
msgbox functionname(range("a1:a10").range)
msgbox functionname(range("a1:a10"))
msgbox functionname("a1:a10")
msgbox functionname(a1:a10)


--
Thanks,
Mike