Calculating a Range

[Matty440]

I am trying to work out how to get Excel to calculate a range.I am using MSProject and VBA to export the timeline to clipboard, open excel and run a macro which will then save that timeline as an image file. The basic principles work fine and I can export whole timelines to my hearts content. I am now trying to get the system to only save a portion of the timeline as the image with the size and postion dependent on data from MSProject. I have got MSProject to pick out the dates I want and work out where that is on the timeline but I am having difficultly in communicating that to Excel.The process for saving the image is to select a range of cells, copy them, create a blank chart and paste the cells into it. this chart is then saved as the image. My difficulty is coming from specifying that range. MSProject is working out the integer values of the rows and columns but Excel won't recpognise that. I have tried turning on the numbered column fuction but it doesnt work. Can anyone help on this?Matt