Hi,
Please see the attached example. I have hightlighted my required output in the yellow.
I need to insert this activity in one of my script.
Please help me with script for this until the data ends in the column A.
Regards,
Vimala
Hi,
Please see the attached example. I have hightlighted my required output in the yellow.
I need to insert this activity in one of my script.
Please help me with script for this until the data ends in the column A.
Regards,
Vimala
Try this to see if you get the desired output.
Please find the attached sheet and click on the Green Button to get the desired output.![]()
Sub vimalanathk() Dim rng, cell As Range Dim lr As Long lr = Cells(Rows.Count, 1).End(xlUp).Row Set rng = Range("A1:A" & lr) Application.ScreenUpdating = False For Each cell In rng cell.Select If cell <> "" And IsNumeric(Left(cell.Offset(1, 0), 1)) Then cell = cell & " " & cell.Offset(1, 0) cell.Offset(1, 0).ClearContents End If Next cell Application.ScreenUpdating = True End Sub
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Its giving me the output in column A itself where as I need the output in column G.
Regards,
Vimala
See the attached sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks