Excel 2007 : Using the values in a dynamic range in another part of a spreadsheet

[qaliq]

Once you have created a dynamic range is it then possible to have the values in it listed out somewhere else in your spreadsheet?

For example, I have created a dynamic range called 'price' which (using offset and match), works out the price for 12 months from a start date you specify. I now want to be able to use these values in a table in a different place in my spreadsheet. I have tried selecting 12 cells, and inserting my name and ctrl+shift+enter for an array but it gives me a ref error. I know my dynamic range works as I can see the correct blinking box when I go into name manager.

If I amend my range so that it just refers to a static 12 cells I can get this to work fine, it's just with the dynamic range that I'm having a problem...does anyone have any ideas?

Thanks,

Alice

[qaliq]

I've actually solved this now....turns out there was in issue with my range rather than the array!