How do i setup a macro to clear cells in Excel?

[Guest]

I need to create a maco to clear input cells in excel. Please help!

 

[Tom Ogilvy]

worksheets("Sheet1").Range("B9,D15,H12,M3").ClearContents

 

[Paul B]

TimTam, something like this,

Sub Clear_Range()
Range("A1,A5,A10,A15,D14,F2").ClearContents
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

sub ClearStuff
sheets("Sheet1").range("A1:A10, B3, C56").clearcontents
end sub

Just change the "A1:A10, B3, C56" to what ever range you need...