Hi there,
I am struggling with the (non)compatibility of Excel 2003 VBA code vs Excel 2010 VBA code.What I want to do is position and scale a chart on the screen based on the position and size of a number of rows/columns. Ideally, I would like to select the cells and position/size the chart to cover the cells (as in Excel 2010).
In Excel 2010, I do it like this:
Now, I can get Excel 2003 to do something similar with the following code (although it doesn't appear very reliable):
Is there someone out there that knows a better way of doing this ... and of automatically recognising which version of Excel is in use and selecting the code automatically?
Would be really grateful for some help here!
Thank you
Bookmarks