判別して記入
Sub 判別して記入() Dim ws1 As Worksheet Dim ws2 As Worksheet Dim lastRow1 As Long Dim lastRow2 As Long Dim keyRange As Range Dim cell As Range Dim keyArray() As Variant Dim keyIndex As Long Dim labels() As String Dim labelIndex As Long Dim label As String ' シート1とシート2を設定 Set ws1 = ThisWorkbook.Sheets("Shee…
2024/04/18 20:28