help with detination

[JohnF]

The below was supplied to me by tactps (works but) in a previous post.

I want the part after the destination to copy the data to a separate workbook the path is C:\Projects\MasterSchedule.xls the sheet is called Master.

If this can be done will it work with the destination workbook closed.

range("A10:A"&[a65536].end(xlup).row).entirerow.copy destination:=Sheets("Master").[a65536].end(xlup).offset(1,0)

 

[Tazguy37]

Try this:

Range("A10:A" & Range("A" & Rows.Count).End(xlUp).Row).EntireRow.Copy Workbooks("C:\Projects\MasterSchedule.xls").Worksheets("Master").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)

Far as I know, it will not work with the destination closed. I've never done that myself, but I searched the board and found some posts on writing to a closed workbook. Here's one. Hope that helps!

 

[JohnF]

Error when this is run

I get a run time error when I run this

Run time error 9

Subscript Out of range

Am I doing something wrong?

 

[Tazguy37]

Are the workbook and worksheet names spelled properly?

And the workbook is open, right?