ExcelBanter - Hiding calculations

Really Thanks.

"MPR Suporte" escreveu na mensagem
...
Hello,

I wrote a procedure that makes some calculations in a range of cells
like
this:

for intnum= 1 to 100
ActiveCell.FormulaR1C1= "=sum(RC[-3]:RC[-1])"
....
....
ActiveCell.Offset(1,0).Select
NExt intnum

The issue is I do no want to see all the cell movements and calculations
during the loop, only the result at the end of the process.

How can I hide the processing of the loop, and then turn it on again.

Thanks in advance
Cesar