removing a formula from a cell in excel

[vb_student]

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.

[Br1an_g]

if you select the cell first and use:

Selection.ClearContents

[vb_student]

thanks for the reply
how do i select the cell from VB?

[Br1an_g]

Range("A1").select

[vb_student]

i got the following code

    Set excel_doc = GetObject("D:\TEST\excel_doc.xls")
    excel_doc.Worksheets("NodeBtypes").Range("E20").Select
    Selection.ClearContents

but the third line(i think) throws up the following error

"run time error '424'
Object required"


also i was wondering if i can specify the cell like say

excel_doc.Worksheets("NodeBtypes").cell(20,5).Select

[Br1an_g]

sorry,

The

Selection.clearcontents

works from within Excel

have a look at this thread for an idea how to reference cells from VB:

Programming Excel from VB6