Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A customer of mine is working with an Excel spreadsheet and has created a
macro that worked in Excel 2000 but is not working in Excel 2003. He has cells that are marked with red text. When he runs this macro he would like the red cells to delete. Do you know why this code is not working? Also, how do I add code to this macro to show the active cell rather than having the curser at the top of the document? ' LateList Macro ' Set LoopRange = ActiveSheet.Range("E3:E250") For Each Cel In LoopRange ' MsgBox (Cel.Font.ColorIndex & ", " & Cel.Interior.ColorIndex) If Cel.Font.ColorIndex < 3 And Cel.Interior.ColorIndex = xlNone Then Cel.EntireRow.Delete End If Next Cel End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to delete a row with a cell containing certain number or text | Excel Discussion (Misc queries) | |||
delete text in a cell using certian criteria | Excel Discussion (Misc queries) | |||
delete part of text from a cell | Excel Worksheet Functions | |||
Delete Spaces and Join Text in Cell | Excel Worksheet Functions | |||
Delete text from cell containing text and numbers? | Excel Programming |