Deleting a range of cells (rows and columns)

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.

Hi Harry,

Can you please tell me where should i write this code in my file. (sorry i am not familiar with excel at all !)

Thanks
Ketan

Hi Dave,

Sorry if i am not very clear, as this is the first time i am using any kind of forums.

I want to clear the contents of a specific data field as soon as i open the excel file, so that i can enter new data in place.

My file has following columns:

Name Tag # Hanger Qty. Package Qty Rate Tax Final Amt.

Tax and Final amt are calculated automatically and rest of the columns i have to fill on daily basis.

So i want a macro by which i can clear the contents of following columns on daily basis :

Name Tag # Hanger Qty. Package Qty



Thanks,
Ketan.