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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to