原來range("a1:a5"),跟range(cells(1,1),cells(5,1))是有差別的. Sheets("1").Select Set tmpRng = Range(Cells(1, 2), Cells(5, 1)) myRng = tmpRng.Address
確定! 回上一頁