Want to cut from worksheet 2 and paste to worksheet 1("Data") been useing
following. Would like to paste without removing validation on sheet 1 paste
special xlvalues etc didn't work rest of procedure works fine
Thanks Much

Selection.Cut
Sheets("Data").Select
ActiveSheet.Paste