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