Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to clear an Excel Worksheet 1

Status
Not open for further replies.
campbere

campbere

Technical User
Oct 10, 2000
146
US
I have figured out to write data out to an Excel Spreadsheet but now I want to clear the worksheet(s) everytime before writing out any data to it. Can someone tell me how to do this?

 
Sort by date Sort by votes
You can use the ClearContents method.
Code: 
Worksheets("Sheet1").Range("A1:G37").ClearContents
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
how to send SMS via free API or other service
Replies
2
Views
389
strongm
strongm
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
494
strongm
strongm
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
368
Ken01
Ken01
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
213
Swi
Swi
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
196
Niki_S
Niki_S

Part and Inventory Search

Sponsor

Back
Top