Re: $$Excel-Macros$$ Wants to do repeated steps of Macro till last column

2013-11-18 Thread xlstime
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

$$Excel-Macros$$ Wants to do repeated steps of Macro till last column

2013-11-18 Thread Amit Desai (MERU)
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