How to prevent copying names when copying ranges

[KDY]

I am copying relatively large amounts of data from a sheet in one workbook to a sheet in another workbook using vba. To speed up the process I am using a method supposed to be faster (data is not copied via the clipboard):

Set RangeWithData = WS_WithData.Range("A1:X1000")
Set TargetRange = WS_Target.Range("C5:Z1004")

RangeWithData.copy Destination:=TargetRange

However, there is a unfortunate side effect: Named ranges from the source workbook are copied to the target workbook with ref to the source workbook as well.

I fail to see the logic, and I would like to avoid this. Any ideas?

 

[wigi]

To speed up the process I am using a method supposed to be faster (data is not copied via the clipboard):

RangeWithData.copy Destination:=TargetRange

Why would this not go to the clipboard? You use the normal Copy command?

You're talking about speeding up code execution. Speeding up in a real way, would be only transferring values, rather than copying entire cells (formatting, ... included):

WS_Target.Range("C5:Z1004") = WS_WithData.Range("A1:X1000").Value

 

[KDY]

Thanks for responding wigi,

As I said: "supposed". Apparently I have been mislead. Just a poor weekend programmer, I am.

I will try to follow your suggestion.

Still bugs me, though, the logic in copying named ranges between the workbooks as a side product of a range copy. Any explanation/justification for this vba behaviour.