PC Review


Reply
Thread Tools Rate Thread

clear the entire active worksheet

 
 
NA_AB
Guest
Posts: n/a
 
      13th Jan 2009
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.
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      13th Jan 2009
Cells.Clear
--
Gary''s Student - gsnu200826
 
Reply With Quote
 
Mike H
Guest
Posts: n/a
 
      13th Jan 2009
Try,

ActiveSheet.UsedRange.ClearContents

Mike

"NA_AB" wrote:

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

 
Reply With Quote
 
NA_AB
Guest
Posts: n/a
 
      13th Jan 2009
hey guys, thanks you both! the question was very trivial one, am a new bie
though. thanks again!

"Mike H" wrote:

> Try,
>
> ActiveSheet.UsedRange.ClearContents
>
> Mike
>
> "NA_AB" wrote:
>
> > 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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make active cell border prominent and keep entire active row selected for better visibility Radhika Microsoft Excel Programming 2 30th Dec 2008 08:51 AM
Clear entire rows below last row of data in col A except in 1st 3 sheets Max Microsoft Excel Programming 6 7th Jan 2008 10:33 AM
How do I clear out my entire contact list? =?Utf-8?B?TWVnYW4=?= Microsoft Outlook Contacts 2 25th Jul 2007 01:27 PM
how to scroll through active cells instead of entire worksheet =?Utf-8?B?bWFyayBzbWl0aA==?= Microsoft Excel Misc 2 13th Mar 2006 02:29 AM
Clear contents of unprotected cells in entire workbook with a macr =?Utf-8?B?Rmlubkdpcmw=?= Microsoft Excel Programming 1 29th Jun 2005 05:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:31 PM.