copy range using last active cell reference from 1 wkb to another

's Computer Specifications

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

's Computer Specifications

Your solution is here:
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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy a range from active cell	Axel	Microsoft Excel Programming	6	9th Apr 2010 12:00 PM
Help: Macro Copy Active Cell to Range Name, loop	peturg@gmail.com	Microsoft Excel Programming	3	30th Mar 2007 08:25 PM
need to Copy or Move to active cell from specified range	kaream	Microsoft Excel Misc	2	14th Dec 2005 08:12 AM
Re: To copy from a range in another sheet to the active cell	William Benson	Microsoft Excel Programming	0	8th Sep 2005 04:47 PM
Macro Copy Active Cell to Range Name, loop	zigstick	Microsoft Excel Programming	6	27th Apr 2005 07:55 PM