AFAIK Having declared the sub you just need to pass the comma delimite
variables without brackets (either as hard code or variable names)
This works with API calls. eg.
MySubroutine 1,"Astring"
If you want a returned value, you have to declare a function and us
the form :-
x = MyFunction MyNumberVariable, MyStringVariabl
--
Message posted from
http://www.ExcelForum.com