What is the difference between functions and subroutines

Subroutines and functions are two types of code procedures. On casual inspection, they appear to be the same. In truth, however, they are different. A subroutine is a piece of code that performs a set of actions or calculations, or a combination of the two. It can form a "building block" within a program and may sometimes need to be repeated. It can be called by several different routines. The End Sub ends the body of the subroutine. After performing the subroutine and functions separately we can conclude the differences in the table below.

Tags: VBA in excel. Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here.

Stay tuned! We provide tips, how to guide and also provide Excel solutions to your business problems. I earn a small commission if you buy any products using my affiliate links to Amazon.

Contact Privacy Policy. What is a Function? A function is something which takes up a number of arguments, does something with them and then returns a value. It can either be built into the programming language or it can be provided by the user. In Perl, when we define a function, we specify the name and the sequence of statements.

There are many built-in functions in Perl which are quite handy too. Perl even allows us to build up our own function which can help us to perform the task that we want to do. What is a Subroutine?

Subroutines or sub give us the ability to give a name to the section of the code so that when we want to use it again in the program, we can use it by just calling its name. Skip to content. Change Language. Related Articles.