thank you all of you guys ;) you're great ;) On Feb 26, 4:33 am, "saravanan" <encubus101...@gmail.com> wrote: > Hi, > > You can also use the below code > > Sub del() > > ro = 1 'Starting Row > > Col = "A" 'Column in which the extra word contains > > While Range(Col & ro).Value <> "" > > If Range(Col & ro).Value = "Extra" Then > > Range(Col & ro).EntireRow.Delete > > ro = ro - 1 > > End If > > ro = ro + 1 > > Wend > > End Sub > > Thanks > > C.Saravanan > > Data analyst > > _____ > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > On Behalf Of jayendra gaurav > Sent: Thursday, February 26, 2009 6:45 AM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Re: problem deleting last cell in a specific row > > U can also use filter option > > rgd > > Gaurav > > On Wed, Feb 25, 2009 at 11:23 AM, Lavprasad Kori <lavprasa...@gmail.com> > wrote: > > Hi Dear, > > Attached herewith the file of solution of your question. In that the > solution is in column E. You have to copy Column E & paste special it in > Column D. > > Regards, > > Lavprasad Kori > > MIS Executive > > Hindustan Unilever Limited > > Mob : 9867931351 > > On Tue, Feb 24, 2009 at 11:11 PM, Mehdi_21 <meh.info <http://meh.info/> > > @gmail.com <http://gmail.com/> > wrote: > > hey everyone > > i'm using a table like this one : > > A B C D > > 1 Main | value | value | value > 2 Extra | value | value | value > 3 Main | value | value | value > . > . > n Extra | value | value | value > > i want to delete every cell in column "D" only when cell in column "A" > contains "Extra" value. > > help plz > regards > > Lavprasad Kori > MIS Executive - Water > Tel. 022 - 39833428 > > -- > J.Gaurav > Asst. Manager > Mahindra logistics > General Motor > Hallol Baroda > Cell - 9327348097
--~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---