Check the code block 4 in the below article to delete entire row based on a blank cell in a particular column (for you it is first column) http://funwithexcel.blogspot.com/2009/05/macros-to-delete-blank-or-empty-cells.html
On Wed, May 20, 2009 at 2:49 PM, tuigje7 <tuig...@gmail.com> wrote: > > How can I change the code below so that VBA deletes any rows in the > current region where th value of the first cell is blank? > > For Each rw In Worksheets(1).Cells(1, 1).CurrentRegion.Rows > this = rw.Cells(1, 1).Value > If this = last Then rw.Delete > last = this > Next > > thanks for your feedback > > > > -- http://funwithexcel.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
