Remove hundreds of empty rows

[drews]

I am working in a workbook with a couple thousand rows and there are several hundred rows that are entirely blank/empty..

How can I select only those rows which are entirely empty and delete them?

[JieJenn]

Like this?

[royUK]

JieJenn please add Code Tags properly then explain how that will remove empty Rows

[JieJenn]

Sorry, I was in editing screen.

[drews]

Thanks for the response JieJenn, however the way that your macro functions is that if only 1 cell is blank but others contain data, that row is still deleted.

I need to be able to only delete the rows that literally have nothing in them.

So for example, I may have a row where columns A, B and C are empty, but D contains needed data; in this case I would not want to delete that row. Does that make sense?

[tom1977]

I use something like this

Please Login or Register  to view this content.

[JieJenn]

Oh gotcha. In that case I would probably add Counta() like the code Tom provided.

[drews]

Perfect tom! Thank you!

[Simon Lloyd]

Also posted here http://www.vbaexpress.com/forum/show...69&postcount=1

[drews]

Quick follow up! I am able to run this script just fine when testing it with 30+ rows... however when I executed it in the workbook I am working on... it ran for awhile (obvious as there are over 2000 rows).. I gave me an error "('1004') Delete method of Range class failed".

Any ideas?

[john55]

drews,
the code works fain, I deleted rows from 349 to 2464, or from 2465 to 65001 (it takes some time but it works)

[JieJenn]

This is the one I used and it works fine for me.

Please Login or Register  to view this content.

[NBVC]

drews,

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).