Would be extremely grateful if someone could kindly help me. I have an excel 2007 workbook which has numerous named ranges which I want to have a macro which can easily transfer the values of those name ranges into another workbook containing the same named but empty ranges.
swhgraham