| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete content in spreadsheet before new computation?
Hi there,
I click on my control "Compute" and then populate my spreadsheet with results on colums C and rows R (actually, the first two rows are my header rows). How can I automatically delete all these worksheet entries before I redo the computation? Thank you for your help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to delete content in spreadsheet before new computation?
Do you mean
Range("A1:J2").ClearContents OR Rows("1:2").clearcontents If this post helps click Yes --------------- Jacob Skaria "FSPH" wrote: Hi there, I click on my control "Compute" and then populate my spreadsheet with results on colums C and rows R (actually, the first two rows are my header rows). How can I automatically delete all these worksheet entries before I redo the computation? Thank you for your help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to delete content in spreadsheet before new computation?
also, to leave your headings in rows 1 & 2 in tact try
range("C3:C" & rows.count).Clearcontents what do you mean by row R? "FSPH" wrote: Hi there, I click on my control "Compute" and then populate my spreadsheet with results on colums C and rows R (actually, the first two rows are my header rows). How can I automatically delete all these worksheet entries before I redo the computation? Thank you for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete content but not formulas | Excel Discussion (Misc queries) | |||
| How do I delete only the content of cells that are NOT protected? | Excel Discussion (Misc queries) | |||
| DELETE CONTENT ADVISOR??? | Setting up and Configuration of Excel | |||
| Delete cell content | Excel Discussion (Misc queries) | |||
| Delete rows by content | Excel Worksheet Functions | |||
Linear Mode
