Loop over to catch the image of every sheet, but always failed to catch the first one on the list when change to another sheet
So I got a list and four sheets in the document. I loop over the my work-group list on each sheet (every sheet produce metrics chart for the work group) then export the sheet image for every item in the list.
Everything was good. But I just cannot catch the first one on the work-group list when I change to another sheet.
this is a sample code for one sheet:
' clean all current choices
' get a list of values in the center listbox
set field1Values = ActiveDocument.Fields("Center").GetPossibleValues