How to delete content in spreadsheet before new computation?

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.
 
J

Jacob Skaria

Do you mean

Range("A1:J2").ClearContents

OR

Rows("1:2").clearcontents

If this post helps click Yes
 
P

Patrick Molloy

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use VBA to Populate Listbox from Open Spreadsheet 4
Select 'used range' except header row in excel 2007 3
Automating complex workbook 3
Problem sorting a range of columns using VBA 1
Delete summary rows programmatically 3
detecting the first blank row in the spreadsheet and populate the blank row with data 2
Iteratively delete rows from a spreadsheet 3
Excel 2003 VBA In directory Open Spreadsheets Extract data 1

Top