Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2012, 08:43 PM
ubns ubns is offline Macro to delete rows with all empty cells Windows 7 32bit Macro to delete rows with all empty cells Office 2010 32bit
Competent Performer
Macro to delete rows with all empty cells
 
Join Date: Apr 2012
Posts: 177
ubns is on a distinguished road
Default Macro to delete rows with all empty cells

Does some one know the macro to delete the emtpy rows - there is nothing in them.
Reply With Quote
  #2  
Old 08-14-2012, 01:58 AM
Venky62 Venky62 is offline Macro to delete rows with all empty cells Windows 7 64bit Macro to delete rows with all empty cells Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2012
Posts: 58
Venky62 is on a distinguished road
Default

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

This may be simpler than a macro
Reply With Quote
  #3  
Old 08-14-2012, 02:01 AM
Venky62 Venky62 is offline Macro to delete rows with all empty cells Windows 7 64bit Macro to delete rows with all empty cells Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2012
Posts: 58
Venky62 is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to delete rows with all empty cells Macro to delete all empty rows from all tables braddgood Word VBA 15 10-02-2015 01:54 PM
Macro to delete rows with all empty cells 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
Macro to delete rows with all empty cells Vba, Is there a better way to test empty cells? Hwyn Excel Programming 2 11-14-2011 11:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft