Delete formula when there is empty space.....

[ru_1985]

HI all,

how to delete away the formula that is assign to the cell When the cell is EMPTY????

for Example: formula is asgin to Columns("C5:C35") to Columns("K5:K35") if there is any empty space in any columns. The formula MUST be delete away automatic .

So that the graph, will not have any point appointed to zero. instead it should left a blank in the graph...

  Range("C5").Select
    ActiveCell.FormulaR1C1 = _
        "=IF(INDEX('AML101-ETCH'!R[-4]C[-1]:R[30]C[-1],MATCH('POLY ETCH CD DATA'!RC[-1],'AML101-ETCH'!R[-4]C[-2]:R[30]C[-2],1))=0,"""",INDEX('AML101-ETCH'!R[-4]C[-1]:R[30]C[-1],MATCH('POLY ETCH CD DATA'!RC[-1],'AML101-ETCH'!R[-4]C[-2]:R[30]C[-2],1)))"
    Range("C5").Select
    Selection.AutoFill Destination:=Range("C5:C35"), Type:=xlFillDefault
    Range("C5:C35").Select

 

[Joe4]

Per forum rules, please stop re-posting the same questions, or variations thereof. Post back to the original thread:
http://www.mrexcel.com/board2/viewtopic.php?t=237530&highlight=