Clear a range

  • Thread starter Thread starter ordnance1
  • Start date Start date
I think this will do that.

Sheets("Sheet1").Range("B1:G7").ClearContents

HTH
Regards,
Howard
 
Sheets("Sheet1").Range("B1:G7").ClearContents

'Other Clear options
'.ClearFormats 'Clears formats only
'.Clear 'Clears all
 

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

Clear a range 1
Range(sheet2) = Range(sheet1) 11
Using .AutoFill with a CELLS() reference 8
Setting a .Range to equal another .Range 5
Defining multiple ranges as one range 4
Copy Data from Sheet 1 to Empty Cell in Sheet 2 2
Problem using Range objects 1
clear all sheets code 4

Back
Top