| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| REPSOT?? Sub Worksheet_Change(ByVal Target As Range) | Excel Discussion (Misc queries) | |||
| Control Toolbox and Private Sub Worksheet_Change(ByVal Target As R | Excel Discussion (Misc queries) | |||
| Control Toolbox and Private Sub Worksheet_Change(ByVal Target | Excel Discussion (Misc queries) | |||
| ByVal Target Range Great Code but need Help | Excel Discussion (Misc queries) | |||
| Private Sub Worksheet_Change(ByVal Target As Excel.Range) | Excel Worksheet Functions | |||
![Jeff[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
