Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Format
Hello,
I'm looking for a good way to delete all the rows that have strikethrough font in columns A. I would like it to do this with out anykind of a loop but cant figure it out. I have tried this: Range("A:A").Application.FindFormat.Font.Strikethr ough = True selection.entirerow.delete But this will only find one and then stop, so right now I am having to do this: On Error GoTo ContinueOnFab Range("A:A").Select Columns(1).Application.FindFormat.Font.Strikethrou gh = True Do Columns(1).Find(What:="", After:=ActiveCell, LookIn:=xlFormulas,LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=True).Select Selection.EntireRow.Delete Loop ContinueOnFab: Thank you, I appriciate your help, Jordan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Format
Look at the help example on the FindNext method.
-- Regards, Tom Ogilvy "Jordan" wrote in message ... Hello, I'm looking for a good way to delete all the rows that have strikethrough font in columns A. I would like it to do this with out anykind of a loop but cant figure it out. I have tried this: Range("A:A").Application.FindFormat.Font.Strikethr ough = True selection.entirerow.delete But this will only find one and then stop, so right now I am having to do this: On Error GoTo ContinueOnFab Range("A:A").Select Columns(1).Application.FindFormat.Font.Strikethrou gh = True Do Columns(1).Find(What:="", After:=ActiveCell, LookIn:=xlFormulas,LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=True).Select Selection.EntireRow.Delete Loop ContinueOnFab: Thank you, I appriciate your help, Jordan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where do i find the numbers tab? i want to use an account format. | Excel Worksheet Functions | |||
find replace format | Excel Discussion (Misc queries) | |||
Find the Format of a cell | Excel Programming | |||
Find/replace format? | Excel Programming | |||
Find & Format Using Macro | Excel Programming |