Small Changes to Code

[painterartist]

I'm afraid this is a very noobie question, any insight is greatly appreciated. I would like to change this code so that instead of

Please Login or Register  to view this content.

it copies cells 3:1112 of whatever column it is in. Then instead of

Please Login or Register  to view this content.

I would like it to select cell D4. I just can't get the syntax right to make this happen and I've confused myself into a corner. I know it must be simple.

Here is the code:

Please Login or Register  to view this content.

[stnkynts]

Maybe this:

Please Login or Register  to view this content.

[painterartist]

Hi Stnkynts,
This is great. The first part is fixed & I see what I was doing wrong, this is a huge help in understanding what I'm doing, thank you. But when I get to line

Please Login or Register  to view this content.

I get "Runtime error 438: Object doesn't support this property or method". The destination sheet is literally blank cells with nothing to get in the way.

[stnkynts]

I didn't want to stray from your code too much but when you are accessing multiple workbooks/sheets you really need to reference them by name. It makes sure the code know exactly where to apply what.

It is a little challenging for me to test this code so I hope I didn't forget anything:

Please Login or Register  to view this content.

[painterartist]

Thanks for getting back to me! I see what you mean & referencing the documents directly & how that will be beneficial. Thank you! I'm trying to figure that out. I keep getting "Compile error: Syntax Error" when I try it. It gets stuck at the Set ws1 point.

Updated based on your last post, I pasted the code below & I also attached the files I am working with. The macro I'm trying to run is in the Cost Template named "Create_PO". Thanks for your patience with me! I am learning a ton from this forum and nice people like you.

Please Login or Register  to view this content.

[stnkynts]

The reason you got the syntax error is because when defining a workbook you need to include some language. :

Please Login or Register  to view this content.

In addition, I was not able to open your attached Cost Template 2014 file. I would verify that you attached the correct and working version and resubmit.

Either way I updated your code. I may have missed something (It's getting late and my eyes are tired). If it errors on you let me know.

[painterartist]

Thank you Stnkynts. I see what you changed & it makes sense now. I will try this today. I was having a lot of trouble getting the Cost Template to upload because it was .xltm. I had to change it to .xlsm in order to upload it. I will try my best with this new code first before bothering you with a new upload. Thank you for making your eyes red and tired looking at my stuff. I am extremely grateful!