Hiding calculations

[MPR Suporte]

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

 

[Bob Phillips]

Hi Cesar,

Precede the code with

Application.Screenupdating = False

and reset it with = True at the end.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

change your code to

ActiveCell.Resize(100,1).FormulaR1C1 = "=sum(RC[-3]:RC[-1])"

 

[MPR Suporte]

Really Thanks.