Hiding calculations

M

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
 
B

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)
 
T

Tom Ogilvy

change your code to

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