Hi, I have a task to delete in a range of 600. For eg I have about more than 1000000 row of data. If is start from row 1-600 I would like to keep row 1 and delete all the way from 2 to 600, then keep 601 and delete all the way upto 1200. What should i write in a code to keep every first row of 600
Hi, thanks for video! But i am strugling with one case: deleting filtered rows in table. How to say to vba "you just filtered rows i need, now delete those, but not all rows and together all table"?.. :D i am stuck. Could you provide some ideas, please?
@@EverydayVBAExcelTraining See, i have more tables along workshit, and in that case vba want to delete entire sheet row...but i need to delete table row only. In stright way we can select table row manually, and in options select "delete table row", now i want to do the same in vba, but there is a problem: Listobject(any).listrows(rowindex).delete I can't use entirerow.delete, becouse i have few tables in my worksheet and i don't want to delete entire sheet row. So, after filter, there can be many rows visible, wich has passed criteria. And i don't know these rows indexes and how to refearence those filtered rows indexes in listrow(rowindex). Also, i guess, i should use some loop in adition? I was trying like: ....listrows(xlvisible).delete But it didn't work properly. So shortly: would like to find some code wich would go to my table, finde rows with criteria, and would delete those table rows, but not entire sheet rows. I started by filtering my table, but failed to delete those...
i have 3 lakhs line , need to delete row based on array value . when i run its takes so much time and never end. I using screen updating , display alerts functions but even though its takes times. anyone pls