How to delete content in spreadsheet before new computation?

  • Thread starter Thread starter FSPH
  • Start date Start date
F

FSPH

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.
 
Do you mean

Range("A1:J2").ClearContents

OR

Rows("1:2").clearcontents

If this post helps click Yes
 
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?
 
Back
Top