View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Nick Cranham Nick Cranham is offline
external usenet poster
 
Posts: 62
Default Problem passing by reference

Bob,
Yes, some code would help this speculation.

NickHK

"Bob Phillips" wrote in message
...
Nick,

He may have declared the same name variable in his function. Who knows,
until we see the code.

Bob

"Nick Cranham" wrote in message
...
Bob,
So he thinks it's being passed ByRef, but really it's being passed

ByVal.

NickHK

"Bob Phillips" wrote in message
...
Not issues, syntax, but anyway that would not appear to be the

problem
as
Ted knows the variable doesn't change when he calls the function

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Nick Cranham" wrote in message
...
There are issues with passing parameters with or without

barckets/Call
statement.

NickHK

"Bob Kilmer" wrote in message
...
It should work as you describe it. Please post code that

illustrates
your
dilemma.
Bob

"Ted" wrote in message
...
I am passing an integer variable into a function. In the
function I am changing the value of the variable. However,
the variable is not changing in the calling function.

I have specifically declared the variable as an integer in
the calling function, and I have specified byRef in the
function being called. However, the value in the calling
function still does not change.

I have tried a couple different variation without success.
Can anyone help me?

Ted