PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Excel > Microsoft Excel Programming > Clear a range

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

« Excel 2007 stops calculating | Need Macro to Sum Range and Paste the Value into one Cell »
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
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 01:36 PM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top