As pointed out by excellent and Joergen, .Validation applies to a range
object and not the worksheet object as in my mistaken example

Regards,
Peter T


"Peter T" <peter_t@discussions wrote in message
...
Unless you particularly need to paste formats go with Mike Fogleman's
paste
values (or paste formulas) solution. Otherwise you could delete
validation,
if you don't need any DV on the destination sheet at all simply

Worksheets("Announcer").Validation.Delete

FWIW, your multi-area copy/paste only works because all areas are same
size,
otherwise would need to do each area separately.

Regards,
Peter T


"Curt" wrote in message
...
My main worksheet has a column with a pulldown for valid entries.
Is there a way to remove this valadation when copying the data in this
column to another sheet.
I have the same problem in another column
The copies are to be used for mail merge if you enter a cell the
validation
comes up not needed now.
here is code I use to copy
Thanks

Worksheets("Data").Range("A4:A200,D4:D200,E4:E200, G4:G200,L4:L200").Copy
_
Destination:=Worksheets("Announcer").Range("A2")