| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Range with Additional Rows to New Workbook
Hi Kimberley,
Just a suggestion: - You could create a defined name for the range of source data. If users add or delete rows between the first and last row, it adjusts itself. To handle users adding rows after the last row, make the definition dynamic. You'll find more info he http://www.contextures.com/xlNames01.html#Dynamic http://www.cpearson.com/excel/excelF.htm#DynamicRanges HTH Regards, GS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto extract data & inserts rows additional rows automatically | Excel Discussion (Misc queries) | |||
| copy rows to another workbook | Excel Discussion (Misc queries) | |||
| Need a macro to copy a range in one workbook and paste into another workbook | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
| Copy Range to new workbook | Excel Programming | |||
Threaded Mode
