Hello,

Could someone help me to a VBA code tot delete cell contents within a range when a specific criteria is met.

Range = A11:L136
Criteria = " "

I think I have to explain, that the " " is the outcome of an If formula. Excel sees the " " as an infinte number and text as well. In Cell A11 is a formula with the outcome " " I have already set up an VBA code to copy and paste values (skip blanks) in cell A11. So the content of cell A11 is no longer a formlua but simply " ". By the way when I stand in cell A11 you will see nothing in the formula bar. Excel shows nothing, but when you use ISTEXT or =A11>1E+100 on cell A11 the outcome of the formula is TRUE.

I hope someone can help me with this.