Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Delete row if cell contents bold text
How can this be modified to delete a row if bold text is in a specific column?
On Error Resume Next Columns(2).SpecialCells(xlCellTypeBlanks).EntireRo w.Delete On Error GoTo 0 Thanks! Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Delete row if cell contents bold text
Dim CCell As Range
On Error Resume Next For Each CCell In Intersect(ActiveSheet.Columns(2), ActiveSheet.UsedRange) If CCell.Characters.Font.Bold Then CCell.EntireRow.Delete Next CCell On Error Goto 0 This only works if the entire cell is bolded; if you need to find if any individual character is bold you would have to step through each Character in CCell.Characters - that would also take significantly more time to run. So hopefully this simple version is what you need. -- - K Dales "Scott Wagner" wrote: How can this be modified to delete a row if bold text is in a specific column? On Error Resume Next Columns(2).SpecialCells(xlCellTypeBlanks).EntireRo w.Delete On Error GoTo 0 Thanks! Scott |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Delete row if cell contents bold text
That didn't work for me. It had problems with successive cells being blank
(as expected). Sub BBB() Dim lastrow as Long, i as Long lastrow = Cells(Rows.Count, 2).End(xlUp).Row For i = lastrow To 1 Step -1 If Cells(i, 2).Font.Bold Then Rows(i).Delete End If Next End Sub avoids that problem. -- Regards, Tom Ogilvy "K Dales" wrote in message ... Dim CCell As Range On Error Resume Next For Each CCell In Intersect(ActiveSheet.Columns(2), ActiveSheet.UsedRange) If CCell.Characters.Font.Bold Then CCell.EntireRow.Delete Next CCell On Error Goto 0 This only works if the entire cell is bolded; if you need to find if any individual character is bold you would have to step through each Character in CCell.Characters - that would also take significantly more time to run. So hopefully this simple version is what you need. -- - K Dales "Scott Wagner" wrote: How can this be modified to delete a row if bold text is in a specific column? On Error Resume Next Columns(2).SpecialCells(xlCellTypeBlanks).EntireRo w.Delete On Error GoTo 0 Thanks! Scott |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Delete row if cell contents bold text
successive cells being blank
should have been successive cells being BOLD -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... That didn't work for me. It had problems with successive cells being blank (as expected). Sub BBB() Dim lastrow as Long, i as Long lastrow = Cells(Rows.Count, 2).End(xlUp).Row For i = lastrow To 1 Step -1 If Cells(i, 2).Font.Bold Then Rows(i).Delete End If Next End Sub avoids that problem. -- Regards, Tom Ogilvy "K Dales" wrote in message ... Dim CCell As Range On Error Resume Next For Each CCell In Intersect(ActiveSheet.Columns(2), ActiveSheet.UsedRange) If CCell.Characters.Font.Bold Then CCell.EntireRow.Delete Next CCell On Error Goto 0 This only works if the entire cell is bolded; if you need to find if any individual character is bold you would have to step through each Character in CCell.Characters - that would also take significantly more time to run. So hopefully this simple version is what you need. -- - K Dales "Scott Wagner" wrote: How can this be modified to delete a row if bold text is in a specific column? On Error Resume Next Columns(2).SpecialCells(xlCellTypeBlanks).EntireRo w.Delete On Error GoTo 0 Thanks! Scott |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Delete row if cell contents bold text
Hi Scott
EasyFilter have this option http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Scott Wagner" wrote in message ... How can this be modified to delete a row if bold text is in a specific column? On Error Resume Next Columns(2).SpecialCells(xlCellTypeBlanks).EntireRo w.Delete On Error GoTo 0 Thanks! Scott |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Delete row if cell contents bold text
Hi Scott
I fixed a bug in the delete option on the color tab of the add-in I upload a new version -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Scott EasyFilter have this option http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Scott Wagner" wrote in message ... How can this be modified to delete a row if bold text is in a specific column? On Error Resume Next Columns(2).SpecialCells(xlCellTypeBlanks).EntireRo w.Delete On Error GoTo 0 Thanks! Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change cell contents to bold | Excel Worksheet Functions | |||
Bold and formated cell wnat to delete in one stroke | Excel Discussion (Misc queries) | |||
Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
Delete rows with bold or italic text | Excel Programming | |||
Bold some of the cell contents | Excel Programming |