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.

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.

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.