摘要:
sub tim dim t t=timer 语句 msgbox timer-t end sub 阅读全文
摘要:
Range("k4") = Range("d:d").Find(Range("j4")).Offset(0, 3) range("d:d").find(range("j4")).offset(0,3).clearcontents '删除找到的内容 sub 查找() dim rng as range 阅读全文
摘要:
Sub drbg()'把目录下所有文件名输入表格Dim str As StringDim wb As WorkbookDim sht As Worksheet str = Dir("d:\data\*.*")'可以把文件名改为"*.xls*"For i = 1 To 100' range("a" & 阅读全文