I need to delete the rows which are marked in yellow which are placed at particular interval.
Please guide.
I need to delete the rows which are marked in yellow which are placed at particular interval.
Please guide.
How aboutPlease Login or Register to view this content.
Hi,
How to use the above mentioned code.
Please guide
Thank You
Kapil
Have a look here https://www.ablebits.com/office-addi...a-macro-excel/
Thank you.
It works.
Kapil
You're welcome & thanks for the feedback
Hi,
Press 'shift'+ 'space bar' and select the rows. Now press 'Ctrl'+'-'to delete the rows.
You could also apply a filter, then filter for the highlighted rows. Then select those rows and hit 'Ctrl' and '-' to delete them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks