| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy range using last active cell reference from 1 wkb to another
I need to copy from cell A9 all cells with data, (the end row varies from day
to day) from workbook1, and place the information on to a sheet called data in workbook 2. I would like to run this macro from workbook2 and the user not see workbook1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range using last active cell reference from 1 wkb to another
Your solution is he
http://www.rondebruin.nl/copy1.htm Other VERY useful resources: http://www.rondebruin.nl/ado.htm http://www.rondebruin.nl/copy7.htm Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jomiop" wrote: I need to copy from cell A9 all cells with data, (the end row varies from day to day) from workbook1, and place the information on to a sheet called data in workbook 2. I would like to run this macro from workbook2 and the user not see workbook1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup cell reference and copy contents and comment from a range | Excel Worksheet Functions | |||
| Help: Macro Copy Active Cell to Range Name, loop | Excel Programming | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| To copy from a range in another sheet to the active cell | Excel Programming | |||
| Macro Copy Active Cell to Range Name, loop | Excel Programming | |||
Hybrid Mode
