VBA to clear data in Google Sheets Office

VBA to clear data in Google Sheets Office So let's say that um in this tab we have data you know some sort of data like this and we want to clear the data let's say from.

A1 to f12 so you can specify a range like we do in excel and then uh we're saying uh the name of the file is going to be this.

And then the range is going to be this the range we want to clear okay um so in google sheet methods if you just specify uh you know like the column like this it's going to.

Delete all the data uh till f call till the last row okay so if you specify exactly the range then it will just.

Uh impact or affect that particular range so starting the uh the service and then terminating the service calling the clear values um.

Method and then it's this is the id so looking up the id again using the file and then this is arranged to clear okay now let me.

DISCLAIMER: In this description contains affiliate links, which means that if you click on one of the product links, I'll receive a small commission. This helps support the channel and allows us to continue to make videos like this. All Content Responsibility lies with the Channel Producer. For Download, see The Author's channel. The content of this Post was transcribed from the Channel: https://www.youtube.com/watch?v=lClK91F3ljo