clear the entire active worksheet

  • Thread starter Thread starter NA_AB
  • Start date Start date
N

NA_AB

how to clear the entire active worksheet at once?! I need something like,
Range.ClearContents() which is for a particular range of cells on excel.
 
hey guys, thanks you both! :) the question was very trivial one, am a new bie
though. thanks again!
 
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

sorting: cleared/null v/s "" 3
clear all sheets code 4
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 2
Macro to combine worksheets 10
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
clear contents on linked sheet 2
The Range property 6
Loop with Step 1

Back
Top