Worksheet calculation

cwng3

New Member
Joined
Nov 7, 2005
Messages
31
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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
Do you get an error?

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

cwng3

New Member
Joined
Nov 7, 2005
Messages
31
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,532
Messages
5,572,729
Members
412,482
Latest member
arooshrana2
Top