This code goes in the sheet code for the sheet you have described as "sheet1", not in a module. Private Sub Worksheet_Change(ByVal Target As Range) ...
確定! 回上一頁