Try this, it should leave E column unchanged.

Range("A2:D100, F2:G100").Calculate

Be sure you have Calculation in Tools Options set to Manual and the Iteration box unchecked.


Regards
Robert McCurdy

"Metallo" wrote in message ...
Hi,

Is there a way to exclude a column from a table calculation by "hiding" it?
I could simply delete all the numbers in the column, but I want to have the possibility to get the numbers back, in case they are
needed.

It's like saying, do the calculation including the data in Column A or exclude them.

A bit like hiding part of the source data in a chart, if you do that, the hidden part will not show in the chart, well I want to
do the same in a table.

Thanks
Alex


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 28/06/2004