Caluclation in a particular section

[chicky36]

Hi,


I have written a macro (Selection.recalculate) so that it can save me some time as all my files are very heavy and it takes so much time in normal calculation (when it calculates whole tab. The problem is that it doesn't tell me how many percent it has already calculated and what is left.


1. Is there any why by which i will be able to see the calculation percentage?

2. is there any why i can stop or pause the calculation in between (when calculating through above marco)?


Thanks in advance


Chicky

 

[nazmul_muneer]

Dear chicky36

Can you upload the coading?


Muneer

 

[chicky36]

Hi Munner,


There is not much coading in it.


(Selection.recalculate)


this is it, by using this it only do calculation in selection area.


Thank


Chicky

 

[chicky36]

Can anyone help???