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.

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

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


"Mint" wrote:

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

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.

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


--


Gary


"Mint" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>