Macro to delete cells containing a formula that results in ""

**adrianodl** · 08-22-2012, 10:33 PM

Hi all,
I've googled left and right about the topic, and all I can find is macros to delete blank cells.

In my case, I want to delete cells (within my selection) that contain a formula, and the formula results in "".

This is the code I'm working on:

Please Login or Register  to view this content.

Any help is appreciated!

Cheers,
Adri

**patel45** · 08-23-2012, 01:04 AM

do you want eliminate cells or rows ?

**adrianodl** · 08-23-2012, 01:07 AM

Hi Patel45,

Ideally, I would like to check if the row has any data. If so, only the cell is deleted.
Otherwise, if the row contains no data, it can be completely deleted.

**HaHoBe** · 08-23-2012, 01:10 AM

Hi, Adri,

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Ciao,
Holger

**patel45** · 08-23-2012, 01:16 AM

Please Login or Register  to view this content.

**adrianodl** · 08-23-2012, 01:27 AM

Hi patel45,
This won't delete the row if blank, is that right?

**HaHoBe** · 08-23-2012, 01:33 AM

Hi, Adri,

could you please be kind enough to tell me the formula that results in ""? I expect a different way to be pratical as well.

BTW: The changed line of code should read

Please Login or Register  to view this content.

And patel45´s code will only delete the cell, for the delete of the row you would need to change to

Please Login or Register  to view this content.

Cia,
Holger

**adrianodl** · 08-23-2012, 02:10 AM

Hi patel45,
Your code

Please Login or Register  to view this content.

does work, but I need to run the macro 2 or 3 times, any ideas why? It doesn't delete all the cells when it first ran.

**HaHoBe** · 08-23-2012, 02:20 AM

Hi, Adri,

this happens due to the fact that patel´s code starts at the top and after a deletion continues in the next row not condering that a ""-Cell may have been shifted up.

The code you found won´t show that because it starts at the bottom and works up. So in total:

Please Login or Register  to view this content.

And what do you really want? Cell deleted or EntireRow?

Ciao,
Holger

**patel45** · 08-23-2012, 04:05 AM

Originally Posted by adrianodl

does work, but I need to run the macro 2 or 3 times, any ideas why? It doesn't delete all the cells when it first ran.

I don't find this problem on my file, can you attach a sample of your ?

**HaHoBe** · 08-23-2012, 04:12 AM

Hi, patel45,

you read my post? Apparently not. Just double up the number of "" in your file/selection and - be surpised to find out.

Ciao,
Holger

**patel45** · 08-23-2012, 08:21 AM

Yes, I did not see with attention, maybe this is solution

Please Login or Register  to view this content.

Macro to delete cells containing a formula that results in ""

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Re: Macro to delete cells containing a formula that results in ""

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions