Užitočné (1) | Kabaka123 |
Sub Bunky_do_jednej() Dim rngSrc As Range, rngTrg As Range, c As Range Dim tx As String Set rngSrc = Selection 'zdrojova oblast - vyznacene bunky Set rngTrg = rngSrc.Cells(1).Offset(0, 1) 'cielova oblast - bunka vpravo od prvej vyznacenej For Each c In rngSrc If c.Text <> "" Then tx = tx & IIf(Len(tx) > 0, ",", "") & c.Text End If Next c rngTrg.Value = tx End Sub
Function Spajaj(zdroj As Range) As String Spajaj = Join(Application.Transpose(zdroj.Value), ",") End Function
Užitočné (1) | Kabaka123 |
Ako vytvoriť makro?