Clear Contents VBA command

[Cquake]

I have a question in regard to the clear contents command in VBA. I am currently using the following for a table with data in it.

Range("A11:w19").ClearContents

It does exactly as it should but I have a row that I don't want the data (Formula)cleared in. For instance in this range listed above the data in row E11:E19 there is a formula in it for calculating the average of row D/C all the way down in it. Is there a way to write the above VBA to omit clearing the data calculated in E:11E:19 so the formula remains there to calculate the next set of data that may be entered.

Thanks,

Bill

 

[shg]

Range("A11:D19, F11:W19").ClearContents

 

[Cquake]

Thanks,