Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:

copy values from a name range

i am copying values from a named range to a different worksheet in the cam workbook.how do i prevent the name range from copying.(duplicate name ranges). thanks
0
Svgmassive
Asked:
Svgmassive
  • 2
2 Solutions
 
Haris DjulicCommented:
Hello,

when pasting values are you using paste special values only or something else?

can you try this:

Worksheets("Sheet_name").Range("Range").PasteSpecial xlPasteValues

Open in new window

0
 
Martin LissRetired ProgrammerCommented:
Or this which copies a named range called "test" which resides on Sheet1, to column "A" on sheet2 starting in cell A1.

Sheets("Sheet1").Range("test").Copy Sheets("Sheet2").Range("A1")

Open in new window

0
 
Martin LissRetired ProgrammerCommented:
I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now