View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_17_] Jeff[_17_] is offline
external usenet poster
 
Posts: 3
Default Is ByVal always better if ByRef isn't necessary

If a variable is not being modified in the passed to sub
or function, is there a reason to specify ByVal rather
than allowing the default ByRef.

And same question if a value is being passed.

In these cases I do not perceive any practical difference
between ByVal or ByRef, but somehow I suspect there is!

TIA for clarifaction,
Jeff