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
Bookmarks