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

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

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

caldog wrote:

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

--

Dave Peterson