把
If UCase(SH.Name) = "NCM REVIEW" Then
SH.Range("A2:F" & SH.Range("A65536").End(3).Row).Copy Range("B65536").End(3)(2)
Range(Range("A65536").End(3)(2), Range("A" & Range("B65536").End(3).Row)) = Ddir(I) & "\" & Split(WB.Name, ".")(0)
Exit For
End If
改成
If UCase(SH.Name) = "NCM REVIEW" Then
SH.Range("A2:F" & SH.Range("A65536").End(3).Row).Copy Range("A65536").End(3)(2)
Exit For
End If