| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to clear contents of certain cells | Excel Discussion (Misc queries) | |||
| clear unlocked cells macro help please | Excel Worksheet Functions | |||
| clear cells macro | Excel Discussion (Misc queries) | |||
| macro to clear cells | Excel Discussion (Misc queries) | |||
| Macro to clear cells | Excel Discussion (Misc queries) | |||
Linear Mode
