Clear Area in Excel sheet

[Gerrit.B]

How can I clear with VBA some Excel sheets (Area A2:N50) before I transfer new data to this sheet from Access 2016.

The transfer (DoCmd.TransferSpreadsheet ) should not add lines, but totally renew all data.

 

[RedBeard]

Read this: ​Clear Cells in Excel Range Worksheet using VBA

 

[Joe4]

A lot of times, when I need to do things to Excel sheets from Access, I will create an Excel macro, and just have Access call and run the Excel macro.
See: Running an Excel Macro from Access (or Another Excel Workbook) – Bacon Bits

 

[Gerrit.B]

Read this: ​Clear Cells in Excel Range Worksheet using VBA

This can be used in Excel sheet, I need the vba code from MS Access.

 

[Joe4]

See the link I provided. It will show you how to run an Excel macro from Access.
I usually find that is the easiest way to go (create an Excel macro that does what you want, and just have Access call that macro to run into of trying to create Excel VBA code in Access VBA).