Macro to Convert Value to Number, Sort, then Delete
Hi
Row deletion with VBA got painfully slow in version 2007 for some strange
reason. I'd do it this way:
1 Insert two new columns (here A and B)
2 Number all rows top to bottom in column A
3 Mark deletion rows in column B
4 Sort by B column. Delete the marked rows
5 Sort by A column to restore original order
6 Delete columns A and B
Best wishes Harald
"cardan" wrote in message
...
Hello,
I have a spreadsheet with copious amounts of data (10 sheets with ~80
columns x 8000 rows). The file size is so large that I need to break
the data into groups and then delete the rows that do not pertain.
I have identified the rows I would like to delete by writing a formula
in Column A. This formula returns the word "DELETE" for the rows I
want to delete.
The best macro would be one that will convert these formulas to its
value and then sorts the data by Column A to get the all the "DELETE"s
into one grouping. I would then need this macro to delete all the
Rows that have the word "DELETE" in column A.
I have a macro that will delete all the rows that have the word
"DELETE" in column A, however it takes forever to run. I can actually
sort and delete quicker manually, however this is an ongoing project
and gets repetitious quickly.
Any help would be greatly appreciated! Thank you for your time.
|