I am in need of exactly what "BJ" wants, it seems to work for him but when I
use it an error message " Invalid Outside procedure" appears and it hight
lights ("G10") in

Range("A").Copy Worksheets("five").Range("G10")

any Ideas as to why this will not work for me?

I am using excel 2007

Thank you in advance,

.................................................. ............................
Thanks Rick - worked great - but I forgot to mention that I need to transpose
the data. How do I work in the PasteSpecial code?

"Rick Rothstein (MVP - VB)" wrote:

Try this statement...

Range("Table").Copy Worksheets("Summary").Range("G10")

Rick


"BJ" wrote in message
...
How do I copy and paste the 'contents' of a Named Range via VBA? I don't
want to copy and paste the range name.

For example, if the Named Range 'Table' is cells A1:F10 of Sheet name
'Data', how do I code in VBA the ability to paste the contents of 'Table'
into sheet name 'Summary' starting at cell G10?

Thank you.