Using the Call Statement
Sub FormatMySheet ()
SameOldRoutine 'goes to Sub name
Do some other stuff
End Sub
Sub SameOldRoutine ()
do the same stuff
End Sub
By putting the name of a sub in another sub, code execution goes to the
named sub, runs that code, then returns to the calling sub to finish it's
code.
Mike F
"caldog" wrote in message
...
I have quite a few of the same set of coding in my Excel VBA. I have been
told, but cannot find any thing in the books that I have, about something
called the 'Call Statement'. Can somebody explain to me or show me how
this
type of VBA code works.
Thanks
|