K
kotlon
Can this be done quickly? For example you have 300 rows and you wanna
delete 1,4,7,10 etc...?
delete 1,4,7,10 etc...?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
a backwards looping macro something like
Sub deleteeverythridrow()
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
Rows(i).Delete
Next i
End Sub
Sub deleteeverythridrow()
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
Rows(i).Delete
Next i
End Sub
N
Nikki
if you don't mind sorting:
what if in a column X you type:
1
2
3
copy and paste it to the end, and then sort by the column, you can then
delete all rows with 3 in column x.
what if in a column X you type:
1
2
3
copy and paste it to the end, and then sort by the column, you can then
delete all rows with 3 in column x.
K
kotlon
You are genious
D
Don Guillett
Did you even try my solution?
N
Nikki
I'm glad it worked for you.
K
kotlon
Don Guillett, yes I have tried your solution and it worked, but I coul
not understand the logic behind the script and when I need to delet
every 2+3+4th row for example I am unable to. Thank yo
not understand the logic behind the script and when I need to delet
every 2+3+4th row for example I am unable to. Thank yo