Thread: Clear a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
arjen van der wal arjen van der wal is offline
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