If value is blank, delete content in selected cell

[thelegazy]

I have a workbook where in column A I have a left statement =Left(B24,3) it gives me like 101, but if there is nothing it is blank, which is what I want. But then there is a macro which takes into account anything in column A and even though the cell is blank there is a formula in there. So, I was wondering if there is any formula that could change that so that the cell's contents would be cleared if there is no value in B24

Thanks!

[Pete_UK]

No. A formula can only act on the cell it is in - it can't "push" data to another cell. Why don't you amend your macro to scan through the cells in column A first, and if any contain "" as a result of the formula then empty the contents?

Hope this helps.

Pete

[thelegazy]

Would you happen to have a macro for that? Or should I start a new thread in the macro section?

[Pete_UK]

No, I don't have one.

Pete

[daffodil11]

Alternatively, if you're pressed for time you could change the original formula to output "xxx" instead of "", and then Ctrl+F to find and replace all xxx with nothing.

But I'd go with modifying the macro because you may even be able to keep the cells as is and evaluate each cell for >0 or <> "" before taking into account the macro action.

[FDibbins]

You need VBA for this, so I will move the thread to that forum

[Leon V (AW)]

Please Login or Register  to view this content.

[thelegazy]

Please Login or Register  to view this content.

Ignore Cell if it is blank (but still has formula)
I have the following code

Please Login or Register  to view this content.

Which will comb through the range and if there is any value it will make a section, but I have a LEFT formula in that range and if it doesn't return a value it still takes it into consideration because there is a value. How do I change it to take cells only that show values (not that show nothing, but still have formulas?

How would i incorporate it into that code?

[thelegazy]

Please Login or Register  to view this content.

It worked thanks so much!!