Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Rows
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
Selecting Rows | Excel Worksheet Functions | |||
Removing Empty Rows and selecting Specific Rows | Excel Programming | |||
Selecting rows | Excel Programming | |||
Selecting Rows | Excel Programming |