Skip to main content
news

Re: spreadsheet ergonomics

owl
Google Google
SubjectRe: spreadsheet ergonomics
Fromowl
Date2017-04-06 19:48 (2017-04-06 17:48)
Message-ID<ahjzv03ga8r.rr@rooftop.invalid>
Client
Newsgroupscomp.os.linux.advocacy
FollowsDFS
DFS <nospam@dfs.com>wrote:

DFS
On 4/6/2017 8:38 AM, owl wrote:

owl
DFS <nospam@dfs.com>wrote:

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

Stopped 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