Exclude a column from a table calculation

M

Metallo

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
 
R

Robert McCurdy

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
 
M

Metallo

Robert,

It does not work.
I went to tools, options, set calculation to manual and iteration was already unchecked.
Then I highlighted the Columns I want in the calculation, press F9 but nothing happens.


Also, I'd like the column which I want to exclude to be hidden, but maybe I can do this after your formula will work??

thanks
Alex
 
M

Metallo

Can anybody reply, please?

Alex

Metallo said:
Robert,

It does not work.
I went to tools, options, set calculation to manual and iteration was already unchecked.
Then I highlighted the Columns I want in the calculation, press F9 but nothing happens.


Also, I'd like the column which I want to exclude to be hidden, but maybe I can do this after your formula will work??

thanks
Alex
Click to expand...
 
Top