What is wrong with this code?

[PATSYS]

I got error message on this line:

  Sheets("Sheet1").Range("MyRange").Copy Destination:=Sheets("Sheet2").Range("A5")

MyRange is a named range.

Thanks

 

[PCL]

It works for me with

Range("MyRANGE").Copy Destination:=Sheets("Sheet2").Range("A5")

 

[Colin Legg]

The code itself looks fine, so it is something about one of your worksheets that is causing the problem.

What is the error message?

Are there any merged cells involved?
Are the worksheets protected?
etc...

 

[PATSYS]

Hi all,

The problem is now solved, and yes it it because of something else, not the code I posted above.

Thanks