Deleteing Rows

[Guest]

In my spreadsheet I have yellow lines that say result. I want to delete these lines. How would I do this?

 

[Ron de Bruin]

Try a example from this page
http://www.rondebruin.nl/delete.htm

 

[Don Guillett]

something like
for each c in selection
if c.interior.colorindex=6 then c.rows.delete
next

--
Don Guillett
SalesAid Software
(e-mail address removed)

In my spreadsheet I have yellow lines that say result. I want to delete

these lines. How would I do this?

 

[Bob Phillips]

Amber,

Here's some simple code that will delete any rows with 'Result' in column A

Application.ScreenUpdating = False

With ActiveWorkbook

With .ActiveSheet
.Rows(1).Insert
.Range("A1").Value = "Test"
.Columns("A:A").AutoFilter Field:=1, Criteria1:="result"
.Cells.SpecialCells(xlCellTypeVisible).EntireRow.Delete
End With

End With

Application.ScreenUpdating = True


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

In my spreadsheet I have yellow lines that say result. I want to delete

these lines. How would I do this?