With Worksheets(lcststrSheetSaikenName)
Set lvarcellichi = .Range("E8:Z8").Find(Trim(lstrArrayList(1)), LookAt:=xlWhole)
If Not lvarcellichi Is Nothing Then
Cells(intLoopCnt - 1 + 9, .Range(lvarcellichi.Address).Column).Value = lstrArrayList(2)
End If
End With
lcststrSheetSaikenName:Sheets名称,
lstrArrayList(1)),:要查询的值
.Range(lvarcellichi.Address).Column :这个值所在列
.Range(lvarcellichi.Address).Rows :这个值所在行
With Worksheets(lcststrSheetSaikenName)
Set lvarcellichi = .Range("E8:Z8").Find(Trim(lstrArrayList(1)), LookAt:=xlWhole)
If Not lvarcellichi Is Nothing Then
Cells(intLoopCnt - 1 + 9, .Range(lvarcellichi.Address).Column).Value = lstrArrayList(2)
End If
End With
lcststrSheetSaikenName:Sheets名称,
lstrArrayList(1)),:要查询的值
.Range(lvarcellichi.Address).Column).Value :这个值所在列