Hi All,

How can i set a different Workbook as my destination using the code
below or the .Copy Destination = property (Both when my destination
file is open or even when it is closed...)

I now use:

Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" &
LastRow).Value

But get a 'type mismatch' when I use
Workbooks("macro new
created.xls").Worksheets(Sheet2).Range("A1:AA" & LastRow).Value =
Range("A1:AA" & LastRow).Value

I recorded a macro, but want to try to use the above method due to
memory / speed issues.

Any help would be greatly appreciated, as always!

To clearify my question: my destination file is open when i run this
macro. (I was just wandering if it needs to be open to work).

On Mar 14, 10:39 am, "artisdepartis" <artispar...@gmail.com> wrote:
> Hi All,
>
> How can i set a different Workbook as my destination using the code
> below or the .Copy Destination = property (Both when my destination
> file is open or even when it is closed...)
>
> I now use:
>
> Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" &
> LastRow).Value
>
> But get a 'type mismatch' when I use
> Workbooks("macro new
> created.xls").Worksheets(Sheet2).Range("A1:AA" & LastRow).Value =
> Range("A1:AA" & LastRow).Value
>
> I recorded a macro, but want to try to use the above method due to
> memory / speed issues.
>
> Any help would be greatly appreciated, as always!

The workbooks have to be open.

And if Sheet2 is the name of the worksheet, I think you'll want:

Worksheets("Sheet2").range(....
(with the double quotes)

artisdepartis wrote:
>
> Hi All,
>
> How can i set a different Workbook as my destination using the code
> below or the .Copy Destination = property (Both when my destination
> file is open or even when it is closed...)
>
> I now use:
>
> Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" &
> LastRow).Value
>
> But get a 'type mismatch' when I use
> Workbooks("macro new
> created.xls").Worksheets(Sheet2).Range("A1:AA" & LastRow).Value =
> Range("A1:AA" & LastRow).Value
>
> I recorded a macro, but want to try to use the above method due to
> memory / speed issues.
>
> Any help would be greatly appreciated, as always!

--

Dave Peterson