Delete Rows w. Multiple Space

[japorms]

Hi Guys,

I need a macro to delete rows with spaces greater than 20. I don't know how excel define a space so I'm not sure where to start.

Can anyone help with this one? Thanks!

[Andy Pope]

Why not post an example workbook which has examples of what you mean by 20 spaces.

Include both types of rows and let us know which you think should be deleted.

[japorms]

Here's a sample

[Andy Pope]

try this,

Please Login or Register  to view this content.

[japorms]

Thanks! It work perfectly.

I'll study this code.