clear defined named cells' contents

[Mint]

i want to make a vba sub in excel file.
My sub is to clear the selected cells.
The cells are all in my defined region.
How can i write the such program.
How can i select the region?
Name("myregion").selected seems wrong.
please advice.
many thanks.

 

[Guest]

Try either
Range("myregion").Clear
or
Range("myregion").ClearContents

Clear will remove formatting and comments as well as the cell contents.

 

[Mint]

many thanks
Sub delete()

Range("Week1").Clear

End Sub

but:
Run-Time error '1004'
Method 'Range' of object '_Global' failed.
Do i have to active a worksheet?
please advice.

 

[Gary Keramidas]

not really, just qualify the range:

Sub clear_range()
Dim ws As Worksheet
Set ws = Worksheets("Sheet1") ' or whatever the name is
ws.Range("Week1").Clear
End Sub