You can't test all the values in a range using Range("A8:A555").Value = "xx" . It will throw a Type Mismatch error. You need to loop through each cell in ...
確定! 回上一頁