Clear using Range Name

[Smurfit-Stone]

Hello Board,

I have created a range name for a large group of cells I need to delete daily to enter new data. I now need some VBA code to clear these cells. I've named the range Reset. I tried recording a macro and replacing the select cell with the range name but it doesn't work. Can anyone help...its probably really simple to most of you, I just need the range name to clear and return the cursor to A1. Thanks in advance

 

[CWatts]

Sub ClearMacro()
'Clears the range
    Range("Reset").Select
    Selection.ClearContents
End Sub

 

[Smurfit-Stone]

Thank you, Thank you, Thank you

 

[CWatts]

I forgot the A1 return:

Sub ClearMacro()
'Clears the range
    Range("List").Select
    Selection.ClearContents
    Range("A1").Select
End Sub

 

[Ruddles]

Or just:-

Range("Whatever").ClearContents

Then you don't need to re-select.

(Have you just changed your avatar?)