Stop calculating a single cell.

  • Thread starter Thread starter Leo Rod
  • Start date Start date
L

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.
 
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.
|
|
 
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.
 
Back
Top