Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify ClearContents
I have a workbook with two worksheets, namely Archive and Data.
The following code clears all the cell in the Archive worsheet when a click event is started. As all cells are cleared, it wipes out any formulae as well! How would I have to modify the code so that it only cleared lines 1 to 500, or certain cells? Sheets("Archive").Select Sheets("Archive").Cells.Select Selection.ClearContents TIA. -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clearcontents for some columns of a row | Excel Programming | |||
ClearContents not clearing :( | Excel Programming | |||
Clearcontents | Excel Programming | |||
Clearcontents | Excel Programming | |||
Clearcontents | Excel Programming |