Hi,

I want to delete a range of cells and columns in my file (eg. A1:K28) as soon as i open the file.

Is there any way to do so ?

Please help me.

I have almost 20 files in which i have to enter data on daily basis. So everytime when i open the file i have to select all the cells mentioned above and delete the data manually. It is very tedious. I would like to have a macro which can delete all the cells mentioned in specific range on opening of that particular file.

Thanks,
Ketan.