View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] qazmlp1209@rediffmail.com is offline
external usenet poster
 
Posts: 5
Default Call by value(and not be reference)!

While debugging the macros, I could observe that, all the arguments are
passed by reference to a function. Is there a possibility to call by
value?
Basically, I want to retain the value of a variable before and after
the function call. The function can take a copy and modify the value of
it, but it should not change the value of the originally passed
variable. How exactly it can be done?