Subject | Re: spreadsheet ergonomics |
From | owl |
Date | 04/06/2017 19:48 (04/06/2017 17:48) |
Message-ID | <ahjzv03ga8r.rr@rooftop.invalid> |
Client | |
Newsgroups | comp.os.linux.advocacy |
Follows | DFS |
DFS
On 4/6/2017 8:38 AM, owl wrote:owl
DFS <nospam@dfs.com>wrote:
DFSStopped by Table: created 2257tables in 7.9 seconds Stopped by Cell: created 6140tables in 27.9 seconds Stopped by Time: created 2978tables in 10.0 seconds
finish: endTime = Timer Debug.Print "Stopped by " & stopper & ": created " & tblCount & " tables in " & Format(endTime - startTime, "0.0") & " seconds"
End Sub -----------------------------------------------------------------------
Stopped by Table: created 2257 tables in 13.1 seconds Stopped by Cell: created 12097 tables in 55.5 seconds Stopped by Time: created 1713 tables in 10.0 seconds -----------------------------------------------------------------------
It ran fine but suddenly quit working and now throws the famous 'Code execution has been interrupted'. Fails on ActiveCell.FormulaR1C1 = "=SUM(R[-9]C:R[-1]C)"
If you have Excel 2003 see if it works for you.