How to delete all filled data

[isay]

Hi,

Currently, I did a VB program in exel that will extract data from a source and will automatically fill data in my exel template.

Please help me with the code on how to delete all filled data in my exel whenever I have new set of source file.

Thanks.

 

[Tazguy37]

If you just want to clear the contents of the cells and keep any formatting, you could use:

Range("D9,D13,D17,G16,G9,I17,H26,E27").ClearContents

Just fill in the cells you're using. HTH