Deleting blank cells that contain a forumula

[joshnathan]

Hey i have a piece of code that does what i want when the cell doesn't havea formula in it.
However, i need it to delete a cell that appears blank even if there is a formula in it.

If not this.
A piece of code that hides a blank cell and reveals it when a value (not a formula) is in it would be great

my stuff so far is simple:

Please Login or Register  to view this content.

[abousetta]

Maybe try this:

Please Login or Register  to view this content.

You can choose whether or not you want to delete the cells or just hide the rows. Also you will notice that when we delete, we begin with the bottom and work our way up to maintain the row numbers.

Hope this helps.

abousetta

[joshnathan]

This seems to be hiding everything including formula and strings
I cant quite work out why.

[abousetta]

Change this row

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Now it will only hide the row if the cell contains a formula and the result is blank.

[joshnathan]

Its now not doing anything.

The cell structure is just as follows for the blank cells: ='CLEAN (2)'!$A12 etc. All other cells that are returning data from Clean (2) have values in them.
Is there any reason why its now not doing anything?

[abousetta]

What does Cell A12 in sheet Clean(2) contain? A space? or is it just blank?

[joshnathan]

It would be blank as its not sending any data through to the new sheet.

[joshnathan]

THe cell is just blank. there is a macro that puts stuff in the cell but it there is no need for anything to be there its just blank not a space.

[abousetta]

There has to be something there because if there wasn't then the result of this formula

Please Login or Register  to view this content.

would be 0

[joshnathan]

I have zero value off atm. I forgot about that.
-.-
I've fixed it now. sorry about that

[abousetta]

If it is working now and you don't have any more questions then please mark the thread as solved.

Thanks.

abousetta