I have a workbook generated and formatted using VBA that displays names and scores from another workbook to display a scoreboard. Using rows.hidden procedures I can filter the data to show the various classes of the scores. All good so far, but after filtering the data I need to create a delay before the procedure calls the next macro that will refilter the classes. The workbook is displayed on a second monitor, while data is updated in the original workbook. Application.Wait will not work as it freezes excel while waiting. What other method could be used?
Bookmarks