Worksheet calculation

[cwng3]

I have just chnaged the macro from:

sheets("TEST").select
ActiveSheet.Calculate

to

sheets("TEST").calculate

It's seem that the spreadsheet cannot start the calculation.

Why? (The spreadsheet calculation option is set to Manual since it take more than 30mins to refresh)

Thanks
TT

 

[Tazguy37]

Do you get an error?

Is there a sheet named "TEST"? (Without the quotes)

 

[cwng3]

Hi,

No any error message. It just finish within few second. Then I tried to use original coding. It spend 30mins to go. So I think the sheet is not "calculated".

The sheet is TEST ( without quote).

Thanks
TT