Hello
I was trying to remove a formula from a cell in excel, till now i have come up with the following

mytype.Worksheets("mytypes").Cells(6 , 6).value = "0"

where the cell (6,6) had the formula, this however leaves the formula updated with the value '0' in place.