about error in macros

ajinkyabedse 

1) Can't execute code in break mode | Microsoft Learn Here is information on how to terminate break mode.

2) Below code returns the intended result in my sheet.

Sub MergeRowsWithLineBreak()

'Select the range of cells that you want to merge.
Dim rng As Range
Dim cell As Range

Set rng = Selection

'Create a new variable to store the merged data.
Dim mergedData As String

'Iterate through the selected range and merge the data into a single string, with line breaks in between.
For Each cell In rng
mergedData = mergedData & cell.Value & Chr(10)
Next cell

'Remove the trailing line break from the merged data.
mergedData = Left(mergedData, Len(mergedData) - 1)

'Paste the merged data into the first cell in the selected range.
rng.Cells(1).Value = mergedData

End Sub