fast question regarding variables

[interner]

I have a sub, inside this sub i call another sub. How do I get the variables from the latter sub to carry over to the firsts sub. Example below.

sub subnum1()
x = 5
y = 8

call subnum2
q = x + y + z
msgbox q
end sub
sub subnum2()
z = 9
end sub

when I attempt to calculate "q" as seen above, the value of "z" from subnum2 is not carried back up. How can I fix this?

 

[VoG]

Maybe like this

Sub subnum1()
x = 5
y = 8

Call subnum2(z)
q = x + y + z
MsgBox q
End Sub
Sub subnum2(z)
z = 9
End Sub

 

[Andrew Poulsom]

Pass the variables as arguments to your second sub, or declare the variables only once at the top of the module.

http://www.cpearson.com/Excel/byrefbyval.aspx

 

[interner]

VoG, you are the f'n man, thank you kindly, sir