Sub Calling Sub Best Practices

[Automate_It]

I'm curious what the community has to say about this:

Which option would be considered Best Practice for calling multiple subs? Aside from speed, which I'm not overly concerned about, does one have an advantage over the other? Why?

Option A:

Sub CallingAllSubs()

   Call Sub2
   Call Sub3
   Call Sub4
   Call Sub5

End Sub

Option B:

Sub CallOneSub()

   Call Sub2
   Call Sub3

End Sub

Sub Sub3()

   Call Sub4
   Call Sub5

End Sub

 

[MUKESHY12390]

Generally there is NO difference.

If your situation doesn't really demand "Option B" I would suggest always go for option A. ( why you give two button if one button does your job).

 

[Automate_It]

Thanks MUKESHY,

I guess it wasn't the best example. It should have been more like this:

Sub Sub1()

   Call Sub2
   Call Sub3

End Sub

Sub Sub4()

   Call Sub5
   Call Sub6

End Sub

I've used the example above when I have a conditional statement where I may need user input. I guess I just find it easier to isolate & work with while testing.