Macro to delete rows with all empty cells

ubns · #1 08-13-2012, 08:43 PM

Does some one know the macro to delete the emtpy rows - there is nothing in them.

Venky62 · #2 08-14-2012, 01:58 AM

Please try the method given in this link: http://www.theexceladdict.com/_t/t031008.htm

This may be simpler than a macro

Venky62 · #3 08-14-2012, 02:01 AM

If you want to do it through VBA: http://www.ozgrid.com/VBA/VBACode.htm

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to delete all empty rows from all tables	braddgood	Word VBA	15	10-02-2015 01:54 PM
Word Empty Cells - Why is it Chr(13) & Chr(7)	tinfanide	Word VBA	2	04-10-2012 01:34 AM
Apparently empty (blank) cells aren't empty	daymaker	Excel	3	03-08-2012 03:41 PM
Empty cells plotted as zero.	ColinC	Excel	2	01-23-2012 08:02 AM
Vba, Is there a better way to test empty cells?	Hwyn	Excel Programming	2	11-14-2011 11:44 AM