UnSelect the copied to range after copy...

  • Thread starter Thread starter L. Howard
  • Start date Start date
L

L. Howard

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
 
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?
Click to expand...

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.
 
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.
Click to expand...

Okay, I tried to do something like that but couldn't string it together. I had it in the back of my mind that almost all codes you have helped me with, seemed there was never a lingering range that was selected.

Thanks.

Howard
 
Hi Claus,

Hmmm, I must be leaving something out that you assumed I would know to do.
This does nothing, arrOut = Empty.

Sub CopyTest()

Dim arrOut As Variant

arrOut = Range("C12:O12")

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

End Sub

Howard
 
Hi Claus,



Hmmm, I must be leaving something out that you assumed I would know to do.

This does nothing, arrOut = Empty.



Sub CopyTest()



Dim arrOut As Variant



arrOut = Range("C12:O12")



Cells(Rows.Count, "Q").End(xlUp)(2) _

.Resize(columnsize:=Range("C2:O2").Columns.Count) = arrOut



End Sub



Howard
Click to expand...

Hold everything! My Bad - My Bad.

I was thinking return goes to C but it was correctly going to Q which was off screen.

Sorry! Sorry!

Howard
 
Back
Top