I have a theoretical question. Say a large procedure is made up of small code chunks/snippets. Would it run slower if these chunks/snippets were placed in separate subs in the same module and called from the original/master sub? (All other factors being equal).
I am afraid I am not explaining myself very well. I'll try again: Of the two methods below, which would run faster?
METHOD 1:
Sub Method1
code snippet1
code snippet2
code snippet3
etc
End Sub
METHOD 2:
Sub Method2
Call Snippet1Sub
Call Snippet2Sub
etc
End Sub
Sub Snippet1Sub
code snippet1
End Sub
Sub Snippet2Sub
code snippet2
End Sub
etc
Bookmarks