![]() ![]() Resstr = Cells(startrow + student - 1, startcol).Offset(0, first - 1).ValueĬells(1, utdata).Offset(startrow + student - 2, 0). Sub findfirstnonzero3()ĭim student, studenter, first, tentor, utdata, yr, startcol, startrow, temp As IntegerĬells(1, utdata).Offset(startrow - 2, 0).Value = "Första tenta"Ĭells(1, utdata).Offset(startrow + student - 2, 0).Value = 0 ![]() using 8 cores (here, I got x2 speed up by using 8 cores on a Mac Air using the new M1 chip). In a previous version for Office 2004, the line "Application.EnableEvents = False" fixed the problem but not anymore in Office 2011. Unfortunately, Python is especially slow with Excel files. For 100 data points in the for-next loop, it takes 10 seconds. ![]() The following macro runs remarkably slowly in MS Excel for Mac (Office 2011). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |