| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear Contents
I have 12 worksheets in my file and I need to clear the contents of only 4 of
them but the ranges I need cleared are different on all 4 of these worksheets. How can I set up vba code to clear the contents with my specified ranges and worksheet names? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clear Contents
Pretty easy
sub clearem sheets("aa").range("a2:x33").clearcontents sheets("bb").range("c22:x333").clearcontents end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Secret Squirrel" wrote in message ... I have 12 worksheets in my file and I need to clear the contents of only 4 of them but the ranges I need cleared are different on all 4 of these worksheets. How can I set up vba code to clear the contents with my specified ranges and worksheet names? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| to clear contents of a spreadsheet | Excel Discussion (Misc queries) | |||
| Clear Contents Of Cells Where Value = 0 | Excel Worksheet Functions | |||
| Code to clear contents | Excel Worksheet Functions | |||
| Clear clipboard contents | Excel Discussion (Misc queries) | |||
| vb to clear cell contents | New Users to Excel | |||
Linear Mode
