It should be like this
msgbox functionname(range("a1:a10"))

Which is passing cells A1:A10 of the acitve sheet to the function. If that
is not working you will need to post your code...
--
HTH...

Jim Thomlinson


"Mike Archer" wrote:

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