I've got a VB app that creates charts based on data selections made by the
user. over time, the stuff in the DB will grow, so there's no easy way to
predict what the size of the chart should be. When it's built, it gets dumped
into a worksheet set aside just for that chart, along with some cells in
which various accumulations (monthly capcity, etc) get posted.

At the moment, the default size of the chart is 'small', (top left at cell
f13, bot-rt at cell p38). I'd like the chart to go from a1 to p38 (or
thereabouts), regardless of the number of data elements used to create it.

I have a book (Excel 2003 VBA Prog ref) that describes the excel obj model.
it implies there are some interesting methods that might be used to set TL
location and height & width -- but it's short on code examples on *how* to do
this.

Any pointers would be very welcome.

Thanks,
Mark (vb newbie)