When another Worksheet is active, you qualify the range with the Worksheet object. Either by Name... Sheets("Sheet3").Range("B5:E8").Border. or by its index ...
確定! 回上一頁