Hi,
I have a worksheet in excel which has lots of rows and three columns
Column A and B have data that is relevant to the list, but column C ha
number "17" appearing on every 17th row. What I want my code to do i
delete every row that has 17 appearing in column C. I have managed t
put this code together, but I cannot make up the crucial bit of it:
With Worksheets(1).Range("C1:C10500")
Set c = .Find(17, lookin:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
XXXXXXXXXXXXXXX
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address < firstAddress
End If
End With
The XXXXXXXXXXXXXXX above is the missing bit. Please help me out.
Thanks in advance.
Ana
--
anar_bak
-----------------------------------------------------------------------
anar_baku's Profile:
http://www.excelforum.com/member.php...fo&userid=1825
View this thread:
http://www.excelforum.com/showthread.php?threadid=50993