ActiveSheet.Calculate not calculating
 

I am using ActiveSheet.Calculate in a Macro to calculate the activesheet. The
Macro has 400lines and every line is perfectly exceuted.

One Worksheet has complex Index formula (array function) that refers to a
large database of 30000 lines.

After the Macro execution , I find the sheet has not been calculated. I had
to manually do it using Shift+F9.

Wht is it happening

ActiveSheet.Calculate not calculating
 

Does the command work if you insert:
DoEvents
after it?
--
Gary''s Student - gsnu200846


"Ananth" wrote:

I am using ActiveSheet.Calculate in a Macro to calculate the activesheet. The
Macro has 400lines and every line is perfectly exceuted.

One Worksheet has complex Index formula (array function) that refers to a
large database of 30000 lines.

After the Macro execution , I find the sheet has not been calculated. I had
to manually do it using Shift+F9.

Wht is it happening

ActiveSheet.Calculate not calculating
 

I'd start by looking at Charles Williams' site:
http://www.decisionmodels.com/calcsecretsh.htm

Maybe it's working correctly, just not the way you want.

If I saw that, then I'd use application.calculate or .calculatefull or
..calculatefullrebuild or whatever I needed to make sure that my data was ok.

Ananth wrote:

I am using ActiveSheet.Calculate in a Macro to calculate the activesheet. The
Macro has 400lines and every line is perfectly exceuted.

One Worksheet has complex Index formula (array function) that refers to a
large database of 30000 lines.

After the Macro execution , I find the sheet has not been calculated. I had
to manually do it using Shift+F9.

Wht is it happening

--

Dave Peterson

ActiveSheet.Calculate not calculating
 

Thanks very much for the hint. Yes, it started recalculating after I used
Worksheets("Tabname").calculate

Ananth

"Dave Peterson" wrote:

I'd start by looking at Charles Williams' site:
http://www.decisionmodels.com/calcsecretsh.htm

Maybe it's working correctly, just not the way you want.

If I saw that, then I'd use application.calculate or .calculatefull or
..calculatefullrebuild or whatever I needed to make sure that my data was ok.

Ananth wrote:

I am using ActiveSheet.Calculate in a Macro to calculate the activesheet. The
Macro has 400lines and every line is perfectly exceuted.

One Worksheet has complex Index formula (array function) that refers to a
large database of 30000 lines.

After the Macro execution , I find the sheet has not been calculated. I had
to manually do it using Shift+F9.

Wht is it happening

--

Dave Peterson