Reputation: 33
I have a code to create a table2 from another table1. I want to add a sub code that would let me delete the data in the table2, refresh the data overall and then continue to create the new table2 based on the refreshed data.
Upvotes: 1
Views: 282
Reputation: 406
Use
Range("A:D").clearcontents
in your code to clear columns
I assumed your range is column A:D
Upvotes: 1