Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleteing Rows
In my spreadsheet I have yellow lines that say result. I want to delete these lines. How would I do this?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleteing Rows
Try a example from this page
http://www.rondebruin.nl/delete.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Amber" wrote in message ... In my spreadsheet I have yellow lines that say result. I want to delete these lines. How would I do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleteing Rows
something like
for each c in selection if c.interior.colorindex=6 then c.rows.delete next -- Don Guillett SalesAid Software "Amber" wrote in message ... In my spreadsheet I have yellow lines that say result. I want to delete these lines. How would I do this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleteing Rows
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.D elete 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) "Amber" wrote in message ... In my spreadsheet I have yellow lines that say result. I want to delete these lines. How would I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleteing | Excel Discussion (Misc queries) | |||
Deleteing empty rows | Excel Discussion (Misc queries) | |||
Deleteing some Rows | Excel Discussion (Misc queries) | |||
Deleteing Blank Rows | Excel Programming | |||
Deleteing Blank Rows | Excel Programming |