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