VBA code to clearcontents of blank cell

[paultje_bos]

Sounds weird, but here's the deal. I have a spreadsheet with formulas. Not all formulas have an outcome, in the case the formula leaves the cell blank ("").
Now I need a vba code that looks in colum A to O for all blank cells, selects them and clearcontents.

 

[Peter_SSs]

.. it seems the issue is due to the cells which are merged.

vba and merged cells often do not get along with each other. This thread is old, but for many I'm sure the sentiment remains.

However, that does not necessarily mean that your particular problem cannot be solved. However, to investigate that it would be helpful if we knew more about just what sort of data you have, where it is, what cells are merged etc. That way we could set up a sample sheet to test & know we were replicating your particular circumstances.

 

[GlennL]

vba and merged cells often do not get along with each other. This thread is old, but for many I'm sure the sentiment remains.

However, that does not necessarily mean that your particular problem cannot be solved. However, to investigate that it would be helpful if we knew more about just what sort of data you have, where it is, what cells are merged etc. That way we could set up a sample sheet to test & know we were replicating your particular circumstances.

Thanks for your help Peter!

I have used Sub JACKs_Clear_EMPTY() as it does the job sufficiently.