| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete every 3rd row
Can this be done quickly? For example you have 300 rows and you wanna delete 1,4,7,10 etc...? -- kotlon ------------------------------------------------------------------------ kotlon's Profile: http://www.excelforum.com/member.php...o&userid=35431 View this thread: http://www.excelforum.com/showthread...hreadid=552000 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete every 3rd row
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 -- Don Guillett SalesAid Software "kotlon" wrote in message ... Can this be done quickly? For example you have 300 rows and you wanna delete 1,4,7,10 etc...? -- kotlon ------------------------------------------------------------------------ kotlon's Profile: http://www.excelforum.com/member.php...o&userid=35431 View this thread: http://www.excelforum.com/showthread...hreadid=552000 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete every 3rd row
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. "kotlon" wrote: Can this be done quickly? For example you have 300 rows and you wanna delete 1,4,7,10 etc...? -- kotlon ------------------------------------------------------------------------ kotlon's Profile: http://www.excelforum.com/member.php...o&userid=35431 View this thread: http://www.excelforum.com/showthread...hreadid=552000 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete every 3rd row
You are genious -- kotlon ------------------------------------------------------------------------ kotlon's Profile: http://www.excelforum.com/member.php...o&userid=35431 View this thread: http://www.excelforum.com/showthread...hreadid=552000 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete every 3rd row
I'm glad it worked for you.
"kotlon" wrote: You are genious -- kotlon ------------------------------------------------------------------------ kotlon's Profile: http://www.excelforum.com/member.php...o&userid=35431 View this thread: http://www.excelforum.com/showthread...hreadid=552000 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete every 3rd row
Don Guillett, yes I have tried your solution and it worked, but I could not understand the logic behind the script and when I need to delete every 2+3+4th row for example I am unable to. Thank you -- kotlon ------------------------------------------------------------------------ kotlon's Profile: http://www.excelforum.com/member.php...o&userid=35431 View this thread: http://www.excelforum.com/showthread...hreadid=552000 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
| Macro to delete a group of CELLS | Excel Discussion (Misc queries) | |||
| in workbook, where is delete worksheet | Excel Worksheet Functions | |||
| how do I delete a worksheet from my workbook | New Users to Excel | |||
| Delete row depending on criteria | Excel Discussion (Misc queries) | |||
Hybrid Mode
