Improper formatting of macro code regarding selection

[Butcher1]

Please Login or Register  to view this content.

I recorded a quick macro from which I pulled the above selection code from and then tried inserting it into the below code.

Please Login or Register  to view this content.

The code will successfully open my word document but then I will get a 'Run time error 1004' Method 'Range' of object'_Global' failed. When I click Debug it shows this line being highlighted

Please Login or Register  to view this content.

What is the proper formatting for this section of code?

[Norie]

What are you actually trying to do with the Word document?

What range are you trying to select in Excel?

[Solus Rankin]

You might try:

Please Login or Register  to view this content.

I'm not that familiar with word.

[Butcher1]

I am trying to copy and paste a range from the Calculator sheet of my excel workbook into a word document. The range is U1:X1 and then Ctrl + Shift+ down arrow to select all the rows that have data in them. Each time this is executed there may be varying amount of rows that have data. I am referring to two youtube videos which deal with this subject in order to set up the macro.

[Norie]

If you want to refer to that range on a worksheet named 'Calculator' you could use something like this.

Please Login or Register  to view this content.

You could then copy the range to Word like this.

Please Login or Register  to view this content.

[Butcher1]

Please Login or Register  to view this content.

Now I get a run-time error 424, object required message. When clicking debug it highlights this line.

Please Login or Register  to view this content.

[Norie]

What's wDoc?

[Butcher1]

http://www.youtube.com/watch?annotat...&v=yJFVTou3QIg

It is how the code is written in this video, much of this is blindly copied so I don't understand many of the fine details.

[Norie]

It should be this.

Please Login or Register  to view this content.

[Butcher1]

Thank you! It is working good enough to figure out the next step.

[Norie]

Did you try downloading the workbook(s) that are mentioned in the video?

[Butcher1]

Yes I did, that is where I got the overall format for this macro.