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...
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...
Code:
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