Using the Call Statement

[caldog]

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

 

[Mike Fogleman]

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

 

[Dave Peterson]

Lots of times, VBA's help is actually helpful. You may want to look there for
Call.