Posted to microsoft.public.excel.programming

Arthur[_3_] Arthur[_3_] is offline

external usenet poster

Posts: 6

Copy & PasteSpecial

Range("A1").Copy
Range ("C1:C5").PasteSpecial (xlPasteValues)

This copies and pastes like I want, but it leaves
the range C1:C5 selected, and cell A1 has the blinking
dotted outline to show it is on the clipboard ready to be
pasted. Is there a way to copy and paste values without
these secondary effects?

Art

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
Cut, Copy, Paste, PasteSpecial grayed out.	news.microsoft.com[_6_]	Excel Discussion (Misc queries)	9	October 19th 17 08:45 PM
Copy Chart and PasteSpecial	PCLIVE	Charts and Charting in Excel	2	October 26th 06 03:01 PM
Copy PasteSpecial not working	Richard Buttrey	Excel Worksheet Functions	9	August 11th 06 04:40 PM
Automate Copy / PasteSpecial	carl	Excel Worksheet Functions	1	March 29th 06 07:07 PM
Copy and pastespecial without formulas	Steven Cheng[_2_]	Excel Programming	2	July 26th 03 08:51 PM

All times are GMT +1. The time now is 03:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us