in reply to Re^2: Excel Chartin thread Excel Chart
Making the range dynamic is as easy as constructing the appropriate string for the range.