Removal of blank rows

[BambiLou]

Without sorting and leaving data as it is received, how do I remove blank rows from workbook

Many thanks
Bambi

 

[BambiLou]

No Leith ... Always copy my data over to a file to play with first

Thanks for the thought
Cheers
Bambi

 

[mirabeau]

Hi BambiLou,

Can I make the comment that you can delete blank rows, generally much faster than the delete entire row methods, by a sorting approach.

This sorting needn't imply that you change the order of your existing rows at all other than moving (i.e. sorting) them to the top of your specified range, and moving the blank rows to the bottom of this range (or vice versa if you so choose).

However, maybe you have reasons for not wanting anything to do with any kind of sorting ...

 

[BambiLou]

Thanks Mirabeau ... The integrity of the data needs to stay as it, that is why I didn't want to do the sort. Now that I have the below macros on a button, they will work without me having to think about it

Thanks a bunch for your comment ... always welcomed

Cheers
Bambi

 

[mirabeau]

That's all good BambiLou.

I didn't want to suggest you do anything else.

But I just didn't want you to stay with the thought that sorting techniques must necessarily alter the integrity of the data.