delete entire blank rows
Hi there!
I would like to delete 2 blank rows only before new item.
What i have done is like this:
But, this code will delete other rows as well. (You can try in the attachment).
Please Login or Register to view this content.
I have more than 2000 line of rows to do it manually.
I'm still new in VBA.
You help are most appreciate. Thanks!
Last edited by isabella; 08-18-2010 at 09:08 PM.
One way, based on your example:
Please Login or Register to view this content.
You need to select a cell in the row to be deleted before pressing the button.
Regards
Thank you for your respond TMShucks.
It works, but I think it is not so practical for the user.
I have the idea to do like this:
If the range between A until E is empty, all rows will be deleted.
I think looping might work but, I still have no luck to do it.
Anyway, thanks for your help!
Try this
Please Login or Register to view this content.
You might need to change this line
Please Login or Register to view this content.
to this
in case column A is not the longest column of data.Please Login or Register to view this content.
N.B. this also removes blank columns.
Hope this helps
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Great!
Thank you very much Marcol. It works nicely.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks