Question: what is difference between procedure and function in vba?
Answer: The main difference between VBA Sub procedures and Function procedures is the following: VBA Sub procedures perform an action with Excel. In other words, when you execute a VBA Sub procedure, Excel does something. ... Function procedures carry out calculations and return a value.