screen updating calling descriptive statistics

**diablo908** · 05-26-2009, 04:53 PM

Hi,

I'm wondering if it's possible to keep the screen from updating when running descriptive statistics in VBA.

I have several calls to run descriptive statistics in a procedure, and when these get run, the screen always flips to the sheet it's running the statistics on and flickers with each statistical run.

Is there a way I can keep the screen static, without it flipping back and forth between sheets? I tried using Application.ScreenUpdating = False at the beginning of the procedure without the desired result.

Here's my descr stats call:

Application.Run "ATPVBAEN.XLA!Descr", Sheets(ForSheet).Range("$D$" & (KMVGAS_index + 1) & ":$D$" & RLNS_index), Sheets(ForSheet).Range("$" & ColumnLetter & "$" & RowNumber), "C", False, True

So is it at all possible to get the screen to stay static during these calls?

**JBeaucaire** · 05-26-2009, 05:56 PM

Use this to turn off screen updating and back on again:

Please Login or Register  to view this content.

**diablo908** · 05-26-2009, 06:00 PM

That doesn't seem to work.

**JBeaucaire** · 05-26-2009, 06:20 PM

Sorry, I missed the line where you said you had tried that. My apologies.

**shg** · 05-26-2009, 06:22 PM

I agree it doesn't work.

If it's a major annoyance, you could change the macro to instead enter separate formulas for each of the components, and then (if desired) replace the formulas with their values.