Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referential Copy and Past
I want to create a macro that copies from one set of cells and copies to the
end of the range without regard to the original size. Currently, all variations copy over the last row of the previous copy, thus deleting one line each time. if the Selection.End(xlDown).Select would index by one each time it would react the way i need it to. Range("A1:C4").Select Selection.Copy Selection.End(xlDown).Select Range("A5").Select ActiveSheet.Paste End Sub Range("A1:C4").Select Selection.Copy c Range("A5").Select ActiveSheet.Paste End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referential Copy and Past
you can use the offset method:
selection.end(xldown).offset(1,0).select "Bob" wrote: I want to create a macro that copies from one set of cells and copies to the end of the range without regard to the original size. Currently, all variations copy over the last row of the previous copy, thus deleting one line each time. if the Selection.End(xlDown).Select would index by one each time it would react the way i need it to. Range("A1:C4").Select Selection.Copy Selection.End(xlDown).Select Range("A5").Select ActiveSheet.Paste End Sub Range("A1:C4").Select Selection.Copy c Range("A5").Select ActiveSheet.Paste End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referential Copy and Past
Range("A1:C4").Copy Cells(Rows.Count, "A").End(xlUp)(2)
"Rob" wrote: you can use the offset method: selection.end(xldown).offset(1,0).select "Bob" wrote: I want to create a macro that copies from one set of cells and copies to the end of the range without regard to the original size. Currently, all variations copy over the last row of the previous copy, thus deleting one line each time. if the Selection.End(xlDown).Select would index by one each time it would react the way i need it to. Range("A1:C4").Select Selection.Copy Selection.End(xlDown).Select Range("A5").Select ActiveSheet.Paste End Sub Range("A1:C4").Select Selection.Copy c Range("A5").Select ActiveSheet.Paste End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Past Values | Excel Discussion (Misc queries) | |||
copy & past row to column | Excel Discussion (Misc queries) | |||
Copy and Past | Excel Discussion (Misc queries) | |||
Copy Past with macro | Excel Programming | |||
Past Link then copy | Excel Discussion (Misc queries) |