Question: what the difference between sub and function in vba?
Answer: The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot.