In article ,
says...
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)



And, what were the results?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions