Stop calculating a single cell.

[Leo Rod]

Is it possible to control the VB "calculate" for a single cell?

I have read and used methods for workbooks and the application but I am not
sure if this can be done to control the calculation of a single cell.

If anybody knows, please let me know,

Thanks in advance!!

Leo.

 

[Niek Otten]

Hi Leo,

Not sure what you mean. The entire workbook can be recalculated except this single cell?

Or do you mean something different?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is it possible to control the VB "calculate" for a single cell?
|
| I have read and used methods for workbooks and the application but I am not
| sure if this can be done to control the calculation of a single cell.
|
| If anybody knows, please let me know,
|
| Thanks in advance!!
|
| Leo.
|
|

 

[Leo Rod]

That is exactly the question Mr. Otten.

I am trying to learn som VB on my own modeling simple things and I came up
with this question to operate an stochastic model that relates to that cell.

I have thought of stopping the calculation on a different worksheet and then
make this cell, on a calculable sheet, a dependant from the other worksheet
that calculates on demand, but if can make it as specific as turn on and off
a cell calculation that will work better for me.

Thanks in andvance for any help regarding this issue.

Respectfully,

Leo.