Copying Data of A Named Range into Another Worksheet

[rommelq]

Hi everyone. I have a simple query. Is there a simple way of copying the data of a named range into another worksheet? Thanks in advance.

 

[Jon von der Heyden]

Hi

As demonstration using paste special (you can of course use regular paste too):

Call Sheet1.Range("your_name_here").Copy
Call Sheet2.PasteSpecial(Paste:=xlValues)
Application.CutCopyMode = False

 

[rommelq]

Hi Jon, thanks for the reply. I wasn't thinking clearly when i post the thread. hahaha. Let me add a few complexities. I have an opened source workbook with named ranges, say, clientsA, clientsB, clientsC. I opened another destination workbook. Instead of copying the data using the copy.paste.value., is there a way wherein in the destination workbook, i just can just call the named range and the vba will automatically copy from the source workbook and paste value them to the destination workbook?