ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Call by value(and not be reference)! (https://www.excelbanter.com/excel-programming/376412-call-value-not-reference.html)

[email protected]

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?


[email protected]

Call by value(and not be reference)!
 
Please ignore my post.

I declared the argument as 'ByVal' and it started working as I wanted.
Thanks!



All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com