ok i have about 200k rows and some of them are blanks and i cant look through all of that and find them.
so does anyone know a macro that can look through a column and if it finds a blank cell it just deletes that row?
Would be much appreciated.
Thanks
Last edited by leon1233; 05-05-2013 at 05:09 PM.
This one's designed to delete all entirely blank rows. You're not clear whether you want this, or any row containing a blank anywhere, or any row with blanks in some specified column. Code is easily modified to whichever.Originally Posted by leon1233
Please Login or Register to view this content.
a non-VBA option...
If you are looking for a specific cell thats blank (say, C1), use this...
=if(C1="",1,0), copied down
It you are looking for a comletely blank row and the range is A1:J1...
=if(COUNTBLANK(A14:E14)=10,1,0)
What you then do, is apply filters (home/editing/sort and filter), then filter on 1 and delete the rows that remain
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks