search

sparkydogX / sparkydogx_blog_comment

Comments for https://sparkydogx.github.io
1 stars 0 forks source link

VBA操作Excel笔记 | SparkydogX Blog #127

Open sparkydogX opened 5 years ago

sparkydogX commented 5 years ago

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(