| 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 |
| 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) | |||
Threaded Mode
