PS. Please be more specific in your feedback ('produces an error' ??; in which line ??)![]()
Sub easy() With sheets(1).usedrange sq=.columns(1).resize(,4) for j=1 to ubound(sq) step 5 sq(j,2)=sq(j+1,1) sq(j,3)=sq(j+2,1) sq(j,4)=sq(j+3,1) sq(j+4,1)="#" next .columns(1).resize(,4)=sq .columns(2).specialcells(4).entirerow.delete .columns(1).replace "#","" End With End sub
Bookmarks