How do Subroutines work

I am trying to run understand how sub routines work. They are very basic so I can understand the concept.
I have a 3 Sub Routines, 1 being the Main one. Sub Main(), Sub Formatting(), Sub Borders
Here is my code. I am getting a Compile error: Sub or Function Not Defined
I want to run "Main" then format and border A1 using Sub routines "Formatting" and "Borders".
What am I doing wrong? Is there a difference in keeping subs in different modules or in the same one?

Please Login or Register  to view this content.

Hi,
See comments in code below:

Originally Posted by 1vision

I am trying to run understand how sub routines work. They are very basic so I can understand the concept.
I have a 3 Sub Routines, 1 being the Main one. Sub Main(), Sub Formatting(), Sub Borders
Here is my code. I am getting a Compile error: Sub or Function Not Defined
I want to run "Main" then format and border A1 using Sub routines "Formatting" and "Borders".
What am I doing wrong? Is there a difference in keeping subs in different modules or in the same one?

Please Login or Register  to view this content.

Thanks.

Ok, nice I am understanding the concept now. Do the subroutines work the same if they are all in 1 module as they would if they are all in separate modules?

Some find it easier to split into separate Modules, you can name the Module for later easier deciphering etc.

If the sub is called by >1 routine, then this would save code repetition.

Your sub's could be incorporated in a single sub instead of 3.

Thanks for the tips.