Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello
i am trying to use this macro for delete from my data every second ROW , but couldn't use there is some error plz help me. thanks in advance. 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(A).Delete Shift:=B:C lShiftUp Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting code from a macro (by a macro) | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
Deleting unwanted data by macro or... | Excel Discussion (Misc queries) | |||
Deleting excess data in a macro | Excel Discussion (Misc queries) | |||
Excel – Macro Problem – Inserting, Appending Data, Deleting | Excel Programming |