VBA to copy data, close then Open another sheet and paste

[daniels012]

I cannot get the order of how to do this.
I know this is incorrect, but is this close?

Range("B5:B18").Copy
ActiveWorkbook.Close
Application.Workbooks.Open DBPathEstim
ActiveSheet.PasteSpecial Format:text
Range("B5")

I wonder if I should have a destination workbook and a current workbook?
And some how Open the workbook: DBPathEstim as my Destination workbook.

Then copy the current data then close the current workbook.

I don't know?
Let me know if you need more info
Thank You,
Michael D

 

[VoG]

You are missing a sheet name in the Destination:= statement.

 

[daniels012]

Ah! Oops! sorry about that. I did indeed change it.
It still gives the Error 9 subscript error though?

Mcihael

 

[daniels012]

Ok, My workbook name was wrong in the second part of the code.
It ran off the page. Can't I add an underscore to code so it is easier to read?

MCihael

 

[VoG]

That means that a workbook name or sheet name is misspelt.