Hi
I have a combobox which when amended runs some code to update the size of a chart to match the number of people in a team. See below for the code, and attached for a stripped down version of the workbook.
It works fine in Excel 2007, but in older versions (specifically XL2000) I get a run-time error 1004: 'Unable to set the Values proprty of the Series class' for each of the last 3 lines. Is there any way round this?Please Login or Register to view this content.
Bookmarks