Posted to microsoft.public.excel.programming

external usenet poster

Posts: 852

UnSelect the copied to range after copy...

Besides Range("A1").Select is there a basic proper method to unselect the just copied to range?

Range("C12:O12").Copy
Range("Q" & Rows.Count).End(xlUp)(2).PasteSpecial Paste:=xlPasteValues

How do I unselect the Q row selected cells without using the Select method?

Thanks,
Howard

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
Range to be copied changes	ConnieM_brd	Excel Programming	5	December 16th 08 08:26 PM
Copy and paste versus copy and insert copied cells	Alana	New Users to Excel	1	September 28th 07 08:58 PM
Copied range. Help please!!	Dev	Excel Programming	4	June 2nd 06 05:22 PM
Unselect range	Biff	Excel Programming	8	September 30th 05 09:31 PM
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied?	excelnovice	Excel Worksheet Functions	2	September 25th 05 12:38 AM

All times are GMT +1. The time now is 02:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us