Worksheet_Change event
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.
|