![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
excel随笔
后台圈
是的风格
展开
-
Excel使用vba选取有数据的范围
Range("A2:K" & Cells(Cells.Rows.Count, 1).End(xlUp).Row).Select原创 2022-12-02 14:24:29 · 3551 阅读 · 1 评论 -
Excel VBA将工作表另存为Excel文件并覆盖文件
Export WorksheetOption ExplicitSub exportSheet() Const FolderPath As String = "C:\Test\" Const FileName As String = "ART.xlsx" Const SheetName As String = "Master List" On Error Resume Next Workbooks(FileName).Close O原创 2021-07-08 16:52:18 · 6762 阅读 · 0 评论