Hello All,

I have the following code:

Please Login or Register  to view this content.
I need to create an array of the bmweff's for the past 12 months to put into a chart. I'm not sure how to do this (month [ jan, feb, etc] and year [2013,2014,2015,2016] are comboboxes populated when the userform initializes). The user selects a combination of the two.

Thanks in advance