컴퓨터/엑셀

vba 셀텍스트합치기

풍경소리^^ 2022. 1. 28. 14:11
Sub 셀텍스트합치기()
    Dim rngS As Range
    Dim strCon As String
    Set rngS = Range("F2", Cells(Rows.Count, "F").End(xlUp))
    strCon = ""
    For Each c In rngS
        strCon = strCon + "'" + c + "',"
    Next
    Range("m2") = strCon
End Sub