VBA操作Excel笔记 | SparkydogX Blog

[sparkydogX]

https://sparkydogx.github.io/2019/07/17/vba-notes/#more

修改单元格Application.Workbooks(1).Worksheets(1).Cells(1,1) = 100 每次修改数据后不要更新显示，可提高运行速度12Application.ScreenUpdating = FalseApplication.ScreenUpdating = True 打开一个新的workbookWorkbooks.Add expression.Evaluate(