an
>
> 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
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
U can also use filter option
rgd
Gaurav
On Wed, Feb 25, 2009 at 11:23 AM, Lavprasad Kori 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 Ko
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 wrote:
Assuming that your data does not have any empty rows:
Sub DeleteWhereExtra()
Dim I As Integer
For I = 2 To Worksheets("Sheet1").Range("A65535").End(xlUp).Row
If Worksheets("Sheet1").Range("A" & I).Value = "extra" Then
Worksheets("Sheet1").Range("D" & I).ClearContents
