Hi,Check the below link, http://funwithexcel.blogspot.com/search/label/Delete to learn about various types of deletes (deleting blank cells / rows / columns, deletion based on a value etc.,)
On Thu, Jun 4, 2009 at 7:35 AM, Hemant <hemantbales...@gmail.com> wrote: > > Do it simply without using a macro: > > 1) Insert a row at the top > > 2) write the formula in the inserted row (say the column is "A" and > the inserted row is "1") =COUNTA(A2:A99999) > (it will give the count of non blank cells in the column) drag > the formula for the entire row > > 3)select the cells in the new row having the value 0 > > 4) Delete the entire column in the selection > > > > -- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---