giani1984
10-06-2016, 04:56 AM
HI all!
Excouse me because my Englisch, it isn't very good...
My problem is that I have a great workbook which can calculate only slowly (10.000 rows, 170 columns consist the source data sheet; 10.000 rows, 70 columns consist the counter (calculater, evaluater) sheet, 10.000 rows, 45 columns consist the display sheet).
I have made a macro, which initialize the parameters on the main sheet, and it start the calculate (re-calculate), because it set to Manual (Application.Calculation = xlCalculationManual). This macro hasn't got any loop...
Could you somebody write an easy (easyest:-) ) subroutine, which can execute / take it:
When my macro start and run (copying, clearing, resizing tables, calculating during 5 minutes and save), this subrutine display an label on an userform, where is an time counter, which display, how many seconds gone...
Thank You everybody for help,
Giani
Excouse me because my Englisch, it isn't very good...
My problem is that I have a great workbook which can calculate only slowly (10.000 rows, 170 columns consist the source data sheet; 10.000 rows, 70 columns consist the counter (calculater, evaluater) sheet, 10.000 rows, 45 columns consist the display sheet).
I have made a macro, which initialize the parameters on the main sheet, and it start the calculate (re-calculate), because it set to Manual (Application.Calculation = xlCalculationManual). This macro hasn't got any loop...
Could you somebody write an easy (easyest:-) ) subroutine, which can execute / take it:
When my macro start and run (copying, clearing, resizing tables, calculating during 5 minutes and save), this subrutine display an label on an userform, where is an time counter, which display, how many seconds gone...
Thank You everybody for help,
Giani