Perhaps this code can help you:

Sub mergge()
For I = 1 To 10
If Cells(I, 2).Value = "Prathap" Then
Range("A" & I & ":C" & I).merge
End If
Next
End Sub

--
Gary''s Student - gsnu200769


"deepika :excel help" wrote:

i have written the following code to merge cells inside a macro.



Name = "Prathap"
S = 1
e = 1
For i = S To e
If (Name < Sheets("FTP").Cells(i, 2).Value) Then
Range(B,start:B,end)
Name = Sheets("FTP").Cells(i, 2).Merge
S = i + 1
e = i

Here what i wanted to convey is taht i want to merge all the cells of
columns A ,B and C for a particular name i col B. teh rest of teh columns
need not be merged . and then the following name is also to bemerged the same
way.
The entries are dynamic . Im not able to proceed beyond this as im new to
coding