All I want is to - Delete Multiple Consecutive Blank Rows
For eg:
excelforum.com
excelforum.com
.
.
.
.
.
.
excelforum.com
.
.
.
.
.
excelforum.com
excelforum.com
excelforum.com
.
.
.
excelforum.com
.
.
.
.
.
.
excelforum.com
.
.
.
.
.
Should be like:
excelforum.com
excelforum.com
excelforum.com
excelforum.com
excelforum.com
excelforum.com
excelforum.com
excelforum.com
The Dots (.) are Blank Rows
I will be very gratefull to you. Please help
Last edited by raw_geek; 11-15-2012 at 10:13 AM.
sort then delete the blanks? if you want to put the info back afterwards first number down in a spare column. after deleting the blanks sort again by that column
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I want to delete the blank rows. The Dots (.) are Blank Rows
attached are the exp. screen shots ..Pls help
Attachment 193770Attachment 193771
I hope this will help you!
Last edited by raw_geek; 11-14-2012 at 07:44 PM.
apply filters, filter by blanks, delete those rows, remove filters
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
both will work
It may be convenient for you with a button? Also faster without the sort (in case you delete many rows at once):
This code can be attached to a button, then just select any cell in the row (or rows) you wish to delete. If needed, this code can be modified to check if a row is empty using Application.CountA(xMyCell.EntireRow) = 0 before deleting.
Please Login or Register to view this content.
Last edited by jimmalk; 11-15-2012 at 12:39 AM.
Thanks all
Last edited by raw_geek; 11-15-2012 at 07:35 AM.
Thanks!
Need some help
Last edited by raw_geek; 11-15-2012 at 07:36 AM.
Thank you gor your help but when I applied filters, I did not get blank option to sort and I got only (.) and excelforum.com. looking some macros....Originally Posted by FDibbins
probably I am wrong..Sorry
This is working but is there anyway run this macro without selection the raw? Thanks!It may be convenient for you with a button? Also faster without the sort (in case you delete many rows at once):
This code can be attached to a button, then just select any cell in the row (or rows) you wish to delete. If needed, this code can be modified to check if a row is empty using Application.CountA(xMyCell.EntireRow) = 0 before deleting.Please Login or Register to view this content.
Raw-geek,
It can be done using a simple code, but to do it, you need to attach a sample excel book, so that we can test it.
Please Login or Register to view this content.
Please see the attached file.
Sheet1 is my current data(Before)
Sheet2 what i need (After)
Thank you in advance
Last edited by raw_geek; 11-16-2012 at 03:15 PM.
I am missing some data...Please Login or Register to view this content.
hi raw_geek, please check attachment, press "Run" button
Please Login or Register to view this content.
What I want say!!! you are awesome! thanks lot!!!
Thanks all..............
Go..Go..http://www.excelforum.com
You're very welcome Raw-geek. Yes, the solutions from Watersev & AB33 look perfect for what you need to do. Good luck
Last edited by jimmalk; 11-15-2012 at 07:50 PM.
Thansk! all works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks