Hi,
In school, I have a worksheet that enables me to choose a student. Below is listed every possible Subject. It uses index/match lookups to find data relevant to that student. I am using code attached to the sheet (View Code) to hide rows with no data. This is made as a Worksheet.Change Event so whenever I select a different student it automatically refreshes to display only those rows applicable to the student. All of this works fine.
I now want to create a macro that will print the sheet for all of the students, one-by-one. The process of changing the student selection one-by-one is fine, within a For ... Next loop. However, I cannot get it to run the worksheet code to refresh the rows displayed, before printing the sheet. So the data is updating from one student to the next, but the display of the appropriate rows is not.
So, any ideas what instruction I need to put in the macro to make the worksheet.change happen?
Many thanks...
Bookmarks