| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
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 (E-Mail Removed) "Curtd" <(E-Mail Removed)> wrote in message news  2018872-F768-432C-B265-(E-Mail Removed)...>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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Just filter the column for blanks (Data>Filter>Autofilter), 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" <(E-Mail Removed)> wrote in message news 2018872-F768-432C-B265-(E-Mail Removed)...>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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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 > (E-Mail Removed) > "Curtd" <(E-Mail Removed)> wrote in message > news 2018872-F768-432C-B265-(E-Mail Removed)...> >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 > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| deleting blank rows for up to 60000 rows of data | gbpg | Microsoft Excel Programming | 3 | 27th Dec 2009 08:37 PM |
| Deleting blank rows which contain blank drop-down list boxes | Al | Microsoft Excel Programming | 2 | 18th Feb 2009 01:37 PM |
| I need a gap when the result of a formula is blank or zero | vsoler | Microsoft Excel Charting | 3 | 12th Jun 2008 04:27 PM |
| How do I get rid of blank rows between data and Ctrl End result? | =?Utf-8?B?WW91bmdibG9vZA==?= | Microsoft Excel Misc | 2 | 19th Apr 2006 09:50 PM |
| Re: deleting the rows depending on the result of a condition involving two columns. | pkseelam | Microsoft Excel Programming | 0 | 26th Aug 2003 02:52 PM |
