Functions

Hi Vishal

Thank you for your question.

There are two types of procedures, function procedures and sub procedures.

Function procedures differ from sub procedures in that they return a value. As a result, they take information in the form of arguments and process that data to generate a value. Function procedures cannot be used to modify the structure of a worksheet, e.g. formatting fonts etc.

Sub procedures have more general uses, and can be used to manipulate the structure of a workbook. Function procedures are often called from within sub procedures.

Regards

Stephen