Hello Team, I need help on the below scenario.
1. I have a 50 columns of data, in this I need delete multiple entire column("C:F", "K", "AA:AD") how do I do this. I have listed all the column heading in column which needs to be deleted - need code for this. 2. I need to delete few rows based on multiple conditions like column1(equals = "AP"), column5(less than 10), column 14(equls = 0). - need code for this. (filter based on this cell and delte the same). Thanks in advance. Regards, Vin -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel