PC Review


Reply
Thread Tools Rate Thread

Clear a range

 
 
ordnance1
Guest
Posts: n/a
 
      8th Nov 2009

How would one clear the range B1:G6 on Sheet1 (which is not the active sheet)?
 
Reply With Quote
 
 
 
 
arjen van der wal
Guest
Posts: n/a
 
      8th Nov 2009


Sheet1.Range("B1:G6").ClearContents

or

Sheets("Sheet1").Range("B1:G6").ClearContents
 
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
Clear a range ordnance1 Microsoft Excel Programming 2 9th Nov 2009 03:11 AM
Clear Range problem Jac Tremblay Microsoft Excel Programming 2 15th Jun 2009 03:56 AM
Clear Range scott Microsoft Excel Programming 3 20th Dec 2007 02:46 AM
Sub to clear range above n below diagonal Max Microsoft Excel Programming 8 27th Sep 2007 06:48 AM
Clear a range of cells Joe@excel Microsoft Excel Discussion 6 25th Nov 2005 06:28 AM


Features
 

Advertising
 

Newsgroups
 


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