Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > Clear a range
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 52
Default Clear a range

How would one clear the range B1:G6 on Sheet1 (which is not the active sheet)?
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 24
Default Clear a range


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

or

Sheets("Sheet1").Range("B1:G6").ClearContents
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Clear a range ordnance1 Excel Programming 2 November 9th 09 03:11 AM
Clear a range of data Patrick C. Simonds Excel Programming 4 March 16th 09 07:50 PM
Clear Range scott Excel Programming 3 December 20th 07 02:46 AM
Sub to clear range above n below diagonal Max Excel Programming 8 September 27th 07 06:48 AM


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement