deleting blank rows issue

[gdallas]

Is there a more efficient way to delete blank rows than this following code? The reason I ask is, this requires you to have data in column A but I have lots of scenarios where column A may not have anything, but the rest, or other collums in its corresponding row, do. I only really want something to delete completely blank rows.
Any ideas?
Range("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

[sktneer]

You may try something like this....

Please Login or Register  to view this content.

[Winon]

@ sktneer,


Good solution!

For the benefit of those who have deliberate Empty Rows above their Data Set, it might be a good idea to provide for such instances,i.e.;

Please Login or Register  to view this content.

Regards.

[sktneer]

Thanks for the feedback Winon!

[gdallas]

that appears to be pretty much perfect mate. Thank you very much

[Winon]

Hi gdallas,

Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.

[sktneer]

you're welcome gdallas! Glad it resolved your issue.
And thanks for the feedback as well.

As Winon said, if that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[gdallas]

hmmm, it doesn't actually appear to work for me after all. i have a data set 91k rows deep, and the when i run this macro on it, it does nothing. was fine for smaller data sets. is my data too great for it?

[Winon]

Hi gdallas,


I believe that prior to Excel 2010 there was a limit of 8192 rows.

Your profile shows you are using Excel 2007.

Regards.