Mike B
03-19-2007, 01:04 PM
Hi!
I am a new member, also new to VBA. I have a program which was working, however i made modifications and exceeded VBA's size limitation for a single Sub Procedure, therefore I am trying to break the program into five procedures, which I have done. the problem is that i have some variables in the last procedure which gathers the values from the other procedures, I made all of the variables Public trying to increase their lifetime but have not been suscessful. The code structure is:
Sub CalculateTask
Call 1
Call 2
Call 3
Call 4
Call 5
End Sub
Sub 1
Do
code
Loop
End sub
I do this for all five prodcures.
I woud appreciate any help.
Thank you,
Mike B
I am a new member, also new to VBA. I have a program which was working, however i made modifications and exceeded VBA's size limitation for a single Sub Procedure, therefore I am trying to break the program into five procedures, which I have done. the problem is that i have some variables in the last procedure which gathers the values from the other procedures, I made all of the variables Public trying to increase their lifetime but have not been suscessful. The code structure is:
Sub CalculateTask
Call 1
Call 2
Call 3
Call 4
Call 5
End Sub
Sub 1
Do
code
Loop
End sub
I do this for all five prodcures.
I woud appreciate any help.
Thank you,
Mike B