Question: why use vba in excel?
Answer: Within MS Office applications, Visual Basic for Applications allows users to perform myriad functions that go beyond simple word processing and spreadsheet operations. For the typical user, VBA helps to make frequent everyday tasks less repetitive via macros.