i have just add loop
Sub rr()
For i = 3 To 78
Cells(4, i).Select
Selection.Delete Shift:=xlUp
Cells(4, i).Select
Range(Selection, Selection.End(xlDown)).Select
Range(Cells(3, i), Cells(2028, i)).RemoveDuplicates Columns:=1,
Header:=xlYes
Next
End Sub
.
Enjoy
Team
Dear All,
Please Help..
I have just recorded a Macro & wants to do repeated steps in each columns
starting from C to BZ. I have done pasting of few raws 2 more times.. but that
will take long time to reach to last column.. do we have any shortcut or
formula or Loop command...
Range("C4").Sele