View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default UnSelect the copied to range after copy...

Hi Howard,

Am Sat, 26 Jul 2014 22:06:42 -0700 (PDT) schrieb L. Howard:

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


if you write the values into the range instead of pasting the range is
not selected:

arrOut = Range("C12:O12")
Cells(Rows.Count, "Q").End(xlUp)(2) _
.Resize(columnsize:=Range("C2:O2").Columns.Count) = arrOut


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional