Posted to microsoft.public.excel.programming

Curt

external usenet poster

Posts: 469

pastespecial

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why need to use Selection.PasteSpecial vs myRange.PasteSpecial	[email protected]	Excel Programming	4	June 25th 07 05:34 PM
PasteSpecial	KL[_3_]	Excel Programming	1	July 8th 04 02:07 PM
pastespecial	Claude	Excel Programming	2	February 24th 04 01:21 PM
vba pastespecial	joao	Excel Programming	2	November 14th 03 03:31 PM
pastespecial	billQ	Excel Programming	2	July 29th 03 11:39 PM

All times are GMT +1. The time now is 12:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us