Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Blank rows as a result of a formula
I realize there have been numerous discussions on deleting rows with a cell
blank, I can not locate one with what I need that works, I have a column that has some blank cells due to a formula result and need to delete these rows, any help would be appreciated. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Blank rows as a result of a formula
try this idea
Sub deleteblankformulas() For Each c In Range("c10:c15") If c.HasFormula And c = "" Then c.EntireRow.Delete Next c End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Curtd" wrote in message ... I realize there have been numerous discussions on deleting rows with a cell blank, I can not locate one with what I need that works, I have a column that has some blank cells due to a formula result and need to delete these rows, any help would be appreciated. thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Blank rows as a result of a formula
Just filter the column for blanks (DataFilterAutofilter), and select a
custom value of blanks and delete the visible rows. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Curtd" wrote in message ... I realize there have been numerous discussions on deleting rows with a cell blank, I can not locate one with what I need that works, I have a column that has some blank cells due to a formula result and need to delete these rows, any help would be appreciated. thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Blank rows as a result of a formula
I appreciate the help Don, however it did not do the trick.
"Don Guillett" wrote: try this idea Sub deleteblankformulas() For Each c In Range("c10:c15") If c.HasFormula And c = "" Then c.EntireRow.Delete Next c End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Curtd" wrote in message ... I realize there have been numerous discussions on deleting rows with a cell blank, I can not locate one with what I need that works, I have a column that has some blank cells due to a formula result and need to delete these rows, any help would be appreciated. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting blank rows | Excel Discussion (Misc queries) | |||
Deleting Blank Rows | Excel Programming | |||
Deleting blank rows | Excel Programming | |||
DELETING BLANK ROWS | Excel Programming | |||
deleting the rows depending on the result of a condition involving two columns. | Excel Programming |