You didn't name a sheet and a range with the same name, did you?

Sub copynamed()'copy from named rgn to named rng
Range("car1").Copy Range("car2")
End Sub

--
Don Guillett
SalesAid Software

"keri" wrote in message
oups.com...
Hi,

I have this code;

Sub dump()

Sheets("raw1").Select
Range("car1").Select
Selection.Copy
Sheets("car1").Select
Range("a1").Select
Selection.Paste
End Sub

All I am looking to do is to select a named range and copy and paste to
another sheet. However on the Range("car1").Select line i get an
error;

Run time error 1004, Application defined or object defined error

I originally thought this would be a problem with the name of the
range, but I have tried naming a single cell as a range "pink" for
example! and it still doesn't work.

Any clues?

Thanks in advance.