there seem to be a lot of postings to do with Named Range Copying ... but I
have not found a simple answer to this...
I have a set of named ranges (data1, data2 etc) on one worksheet.
On a second worksheet in that workbook I want to be able to insert a copy of
the named range by simply 'pasting' the named range without having to go to
the worksheet and copy the named range, then go back to my first worksheet
and pasting....(am I making sense?)

I can do this on a single cell Name by typing '=Name' and this applies the
single cell data, but this does not accept a named range.

I am sure there is a simple way of doing this ... anyone help?