On Fri, 19 Aug 2005 08:09:03 -0700, "Yasha Avshalumov"
wrote:

I am trying to pass a variable I defined in a different sub to another one so
I dont have to recreate the code in the new sub. I tried passing as some
book sugggest but still having problems. I am having problems with syntax I
believe and can't seem to find my mistake. I tried passing the variable like
this: Sub GetNotes(LastRow as Integer) and I defined the new sub the same
way. This give me a redifined error, saying that I am redifining the
variable, so I tried taking out "as Integer part" but this wont even let me
compile the code. However if I take out the parameters the code complies and
I can step through the code, but I cant do anything with the paraments in the
heading. Please point me in the right direction, becasue I can't seem to
figure out what I am doing wrong.

thanks,

In the sub to which you are passing your variables, define them
between the ( ) brackets

In the originating sub, simply state them within the brackets of the
Call yoursub() command.

e.g.


Sub GetNotes()
Call NewSub(1, "Test")
End Sub

Sub NewSub(MyInteger As Integer, MyString As String)
MsgBox MyInteger & " " & MyString
End Sub


HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________