Have you created an Excel Defined Names for car1?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"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.