Do Until Loop logic help

[VBABEGINER]

Do Until lx = 12
    
Loop

12 is Col L.

how do i mention lx is the column to increment..??

 

[VBABEGINER]

Hi Joe,
Hold on...Let me try myself..If im not able to get successfully, I will put a request to you, then please provide.

 

[VBABEGINER]

Hi Joe, Thanks for replying on all queries.

I hv done.

I have query now, after adding all the data, I want the merge part to be un-merged and paste in their respective areas..

can we do this..

 

[VBABEGINER]

Hi Joe Sir,

I just got it from another post..

An excellent work, I always see on MrExcel.

 Sub Unmerge_Cells()Application.ScreenUpdating = False
Lr = Cells(Rows.Count, 1).End(xlUp).Row
Cells(Lr, 1).Select
Lr = Lr + Selection.Cells.Count - 1
Range("A2:A" & Lr).Unmerge
For r = 3 To Lr
If Cells(r, 1) = "" Then Cells(r, 1) = Cells(r - 1, 1)
Next r
End Sub