| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
UnSelect the copied to range after copy...
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range to be copied changes | Excel Programming | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| Copied range. Help please!! | Excel Programming | |||
| Unselect range | Excel Programming | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
Threaded Mode
