VBA Sub Statement

Excel VBA

How to Return Values from a Sub in Excel VBA (4 Methods)

ExcelInsider Team October 27, 2025

In Excel VBA, a Sub procedure is one of the most common ways to automate tasks. A Sub can perform actions. For instance, calculating results, updating cells, or formatting results. However, it does ...

Excel VBA

Private Sub vs Sub in Excel VBA: All You Need to Know

ExcelInsider Team October 17, 2025

When writing procedures in Excel VBA, you’ll often come across both Sub and Private Sub. While they may look similar, they serve different purposes, mainly when it comes to scope and accessibility. ...