I'm using a script from here: http://www.excelforum.com/excel-form...final-and.html
The script basically gets a collection of cells and comma separates them with a final "and" (as the last comma)
My problem is, the VBA script seems to be running before cell values are calculated. If I change student % scores (sheet 1 "Grades") then the "Top Subjects" column is what it should be just prior to the change of data.
How can I make sure the script executes only when the cells have been fully calculated, so that the results appear accurate when data is updated?
Please examine the attachment: autograder_lags.xlsm
Bookmarks