Clearing cells

  • Thread starter Thread starter hal
  • Start date Start date
H

hal

Other than a tedious looping construct, how can you
quickly clear a large block of cells?

TIA
 
Selection.Clear
Selection.ClearContents

Range("A1:A100").Clear
Range("A1:A100").ClearContents

Clearcontents will only clear the value in it
Clear also the formatting
 
Hal,

Try something like

Range("A1:Z10000").Clear

Or do you have something else in mind?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
You must log in or register to reply here.

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

Clearing Merged Cells 4
Clearing cells but also not clearing other dependent cells 4
Clearing only cells w/ numbers 4
random range of cells via cell names 3
Clearing Hyperlink formating from undefined # of cells in a column 3
sorting: cleared/null v/s "" 3
Exit For statement in nested For ... Next blocks 3
Number format of ranges using cell value 2

Back
Top