View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default MACRO for Deleting every 2nd ROW

Sub abc()
Dim frow As Long, lrow As Long
Dim i As Long
frow = Selection.Row
lrow = Selection.Rows(Selection.Rows.Count).Row
For i = lrow To frow Step -2
Selection.Rows(i).Delete Shift:=xlShiftUp
Next

End Sub

--
Regards,
Tom Ogilvy



"Tufail" wrote in message
...
hello,

I want make a Macro for deleting in selection data every second row, plz
help me.

Thanks/Tufail