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

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

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

worksheets("Sheet1").Range("B9,D1:D5,H12,M3").Clea rContents

--
Regards,
Tom Ogilvy


"TimTam" wrote in message
...
I need to create a maco to clear input cells in excel. Please help!

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

TimTam, something like this,

Sub Clear_Range()
Range("A1,A5,A10,A15,D1:D4,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

"TimTam" wrote in message
...
I need to create a maco to clear input cells in excel. Please help!

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

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

Just change the "A1:A10, B3, C5:D6" to what ever range you need...
--
HTH...

Jim Thomlinson


"TimTam" wrote:

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