文件名称:VBA实现EXCEL多表格多条件查询
文件大小:156KB
文件格式:DOC
更新时间:2016-05-06 02:59:49
VBA,查询
VBA实现EXCEL多表格多条件查询 For i = 1 To Workbooks.Count For Each c In Sheets(i).UsedRange If c.Value >= 150 And c.Value <= 160 Then c1 = c1 + c.Value n = n + 1 End If ‘更多条件…… Next Next