Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ByRef not passing address
Hope some one can help
My problem is when I try to create a function that will increment an integer, the calling parameter I believe is passed as a value and not a reference. The help file suggest that default value of parameters passed is ByRef, but this example tell me in the case of integer its not. Does any one have a work around. My email address is All suggests are welcomed. A coded example would explain all Program dim myValue as integer ..... myValue = 0 increment(myValue) ' here myValue still has value of 0, because it was not passed to subroutine as reference and hence not incremented .... end Program sub increment( number as integer) number = number + 1 end sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ByRef not passing address
This shows passing by ref is in affect:
Sub One() Dim X As Integer Two X MsgBox X End Sub Sub Two(Y As Integer) Y = Y + 1 End Sub -- Jim Rech Excel MVP |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ByRef not passing address
Ian,
Your causing the problem yourself by incorrectly calling the function. increment(myValue) shoud be increment myValue You only use parentheses if you are returning a value (calling a function) or you are using Call Call Increment(myValue) -- Regards, Tom Ogilvy "Ian Stanborough" wrote in message ... Hope some one can help My problem is when I try to create a function that will increment an integer, the calling parameter I believe is passed as a value and not a reference. The help file suggest that default value of parameters passed is ByRef, but this example tell me in the case of integer its not. Does any one have a work around. My email address is All suggests are welcomed. A coded example would explain all Program dim myValue as integer ..... myValue = 0 increment(myValue) ' here myValue still has value of 0, because it was not passed to subroutine as reference and hence not incremented .... end Program sub increment( number as integer) number = number + 1 end sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
Passing Cell Address to Offset | Excel Worksheet Functions | |||
LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming | |||
Is ByVal always better if ByRef isn't necessary | Excel Programming |