Hi,
I start my worksheet with like 30,000 records. After running couple of macros, and I'm down to like 5,000. However in my worksheet I still have 30,000 rows of which like 25,000 are blank.
Is there way of getting rid of those blanks, so the bottom of my is around 5,000? It's annoying having that when I scroll down, it goes to like 30,000.
I have excel 03 and thanks.
One way could be to use Data|Filter|AutoFilter...
Save your workbook first in case of problems.
Then filter one of the columns for Blanks.
Then delete those rows.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
or (still assuming all the columns are the same -- ie if col A is blank then so too are remainder of columns)
highlight column A --> Edit -> GoTo -> Special -> Select Blanks -> blanks now higlighted -- so Edit -> Delete - select Entire Row.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks