Guest User

Untitled

a guest
Jan 16th, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. =A1 & CHAR(32) & B1 & CHAR(10) & A2 & CHAR(32) & B2
  2.  
  3. strMerge = strMerge & Chr(10) & MyCell.Value
  4.  
  5. strMerge = strMerge & Chr(13) & Chr(10) & MyCell.Value
  6.  
  7. Range("C1").Select
  8. With Selection
  9. .FormulaR1C1 = "=CONCATENATE(RC[-2],RC[-1]) & CHAR(10) & CHAR(13) & CONCATENATE(R[1]C[-2],R[1]C[-1])"
  10. .HorizontalAlignment = xlGeneral
  11. .VerticalAlignment = xlBottom
  12. .WrapText = True
  13. End With
  14. End Sub
  15.  
  16. Sub MergeSelectedRowData()
  17.  
  18. Dim MyCell As Range
  19. Dim strMerge As String
  20.  
  21. Dim MyCell2 As Range
  22. Dim strMerge2 As String
  23.  
  24. For Each MyCell In Sheets("Sheet1").Range("A1:B1")
  25.  
  26. If strMerge = "" Then
  27. strMerge = MyCell.Value
  28. Else
  29. strMerge = strMerge & Chr(32) & MyCell.Value
  30. End If
  31.  
  32. Next MyCell
  33.  
  34. For Each MyCell2 In Sheets("Sheet1").Range("A2:B2")
  35.  
  36. If strMerge2 = "" Then
  37. strMerge2 = MyCell2.Value
  38. Else
  39. strMerge2 = strMerge2 & Chr(32) & MyCell2.Value
  40. End If
  41.  
  42. Next MyCell2
  43.  
  44. Cells(1, 3).Value = strMerge & Chr(10) & strMerge2
  45.  
  46. Sub MergeSelectedRowData2()
  47.  
  48. Dim MyCell As Range
  49. Dim strMerge(1 To 2) As Variant
  50. Dim finalStr As String
  51.  
  52. Dim i As Integer
  53.  
  54. For i = 1 To 2
  55.  
  56. For Each MyCell In Sheets("Sheet1").Range("A" & i & ":" & "B" & i)
  57.  
  58. If strMerge(i) = "" Then
  59. strMerge(i) = MyCell.Value
  60. Else
  61. strMerge(i) = strMerge(i) & " " & MyCell.Value
  62. End If
  63.  
  64. Next MyCell
  65.  
  66. If finalStr = "" Then
  67. finalStr = strMerge(i)
  68. Else
  69. finalStr = finalStr & Chr(10) & strMerge(i)
  70. End If
  71.  
  72. Next
  73.  
  74. Cells(1, 3).Value = finalStr
Add Comment
Please, Sign In to add comment