Yes, if the procedure has no arguments, it is simply

Call proc_name

If it hasrgumnets, the values are passed in brackets

Call proc_name(value1, "Text2")

and if it is a function returning a value then any parameters are in
brackets , using call or not

myVar = my_func(param1, param2)

or

myVar = Call my_func(param1, param2)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Joanne" wrote in message
...
So could you give me an example of how to use Call

Do I simply say Call SubName?

Thanks a lot for your help
Joanne

Bob Phillips wrote:

Absolutely not correct.

I always use Call, it helps me to instantly differentiate between my
custom
methods and the VBA built-in methods.