Merge cells that a loop references

Originally Posted by patel45

attach please a sample file with current data and desired result

Hi,

Having trouble attaching sheet.

Essentially, during the following Loop, that goes from one row to another, I want to be able to select all rows that the loop goes through and at the end of the loop Merge the cells.

Hope that makes sense.

Richard

'update counter
Vlength = Vlength - 1
Loop Until Vlength = 0
Application.CutCopyMode = False
ActiveCell.Value = Vdesc


Application.CutCopyMode = False