View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default 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