浅谈 VBA 在工作中的应用

摘要

Based on work experiences in many years,combining with actual examples,application method and techniques of VBA(Visual Basic for Application)which is the inner couplers developing tool of Excellhave been studied.Mathematics calculation with complicated operation steps and a great deal of datas in the process have been solved.It will effectively eradicate mistakes brought by artificial operation.%笔者根据多年的工作经验，结合具体实例探讨了 Excel 内置开发工具 VBA（Visual Basic for Application）在实际工作中的应用技巧，解决了在数据处理过程中繁杂的操作步骤和大量数据的数学计算，有效杜绝了人工操作带来的错误。