Call multiple Subs

[DougStroud]

A general question about Calls.

Calling a Sub from another Sub is quite common, how about a Sub that does nothing else but call all the subs to execute the entire job?

Will the subs run sequentially after one completes, or will there be the likley hood they will bump into each other causing all sorts of chaos...?

 

[kmillen]

Functions do it all.

Function only returns value/object, can not change anything like Sub routine does.

Incidently jinden, I respectfully disagree with this statement. Functions, in fact, add the functionality to subs by having a return value. I can do anything in a function that I can do in a sub AND I get to return a value.

Functions don't force me to exchange functionality for return value; it's all VBA.

 

[DougStroud]

KMillen,
That is a great idea.
I will experiment w/ this and post back.

Thanks

 

[jindon]

Re: Functions do it all.

Function only returns value/object, can not change anything like Sub routine does.

Incidently jinden, I respectfully disagree with this statement. Functions, in fact, add the functionality to subs by having a return value. I can do anything in a function that I can do in a sub AND I get to return a value.

Functions don't force me to exchange functionality for return value; it's all VBA.

Can function:
Change format?
Change other cells' value?
Can add worksheets or workbooks?

What I meant is Function can not do anything by itself.

 

[kmillen]

That's a big YES to all of those questions!

Function WhatCanAFunctionDo()
'
' WhatCanAFunctionDo Macro
' Macro recorded 8/7/2007 by Kerry Millen
'
    
    Range("A1").Select
    ActiveCell.FormulaR1C1 = "A"
    Selection.Font.ColorIndex = 3
    Selection.Font.Bold = True
    Range("B3").Select
    ActiveCell.FormulaR1C1 = "=CODE(R[-2]C[-1]) + 5"
    Range("B4").Select
    Sheets("Sheet1").Select
    Sheets.Add
End Function

Insert this code into an Excel sheet module and run it. A function can do everything a sub can do and return a value.