标签 VBA 下的文章

V

【VBA】遍历文件夹下所有的文件夹名称

Option Explicit Sub 提取文件夹名称() Dim fs As Object Dim f As Object Dim fd As Object Dim n As Integer ...

肉松笔记 2021-08-09

V

Option Explicit Sub dirtst() Dim f As String, i As Long f = Dir("C:\Users...

肉松笔记 2020-11-02

V

Sub inputtxt() Dim s As String, i As Long Open "C:\Users\i\Desktop\xxx.txt" F...

肉松笔记 2019-11-15

V

excel中的常见的单元格错误“#N/A”，在VBA中此内容识别 “Error 2042”在写比对判断语句时要注意区分当单元格中显示#N/A时可以使变量值=“Error 2042”将其筛选出，使...

肉松笔记 2019-10-27

V

Sub xuanzexx() Dim i As Integer For i = 135 To 4 Step -1 If Cells(i, 11) = "" Then...

肉松笔记 2019-10-27