Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a range of cells (a row) to the bottom of a "list"
I am collecting cells from a worksheet into a row. Each time I run a macro I
want this row of cells to be copied to the bottom of another range. This range is increasing in size as new rows are added. Whats the best way to programaticcally do this? I have tried to use to use the End(xlDown)-method, but I wonder if there are better methods to do this? Thanks Torstein S. Johnsen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a range of cells (a row) to the bottom of a "list"
What's wrong with End(xldown)?
That is pretty standard. Specific information might provide some additional suggestions. Where is the range. Is is isolated. Does it always start in a certain location. Is it always contiguous at least in one column (no completely empty row in the range). set rng = Range("Z21").CurrentRegion.Columns(1).Cells Selection.Copy Destination:= rng.rows(rng.rows.count+1) -- Regards, Tom Ogilvy "Torstein Johnsen" wrote in message ... I am collecting cells from a worksheet into a row. Each time I run a macro I want this row of cells to be copied to the bottom of another range. This range is increasing in size as new rows are added. Whats the best way to programaticcally do this? I have tried to use to use the End(xlDown)-method, but I wonder if there are better methods to do this? Thanks Torstein S. Johnsen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
advanced filter dialog box, "List Range" list two ranges? | Excel Worksheet Functions | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
"Create a drop-down list from a range of cells" | Excel Worksheet Functions | |||
Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) |