Opening file, copy and paste range

Hello everyone,
I'm sure this is a very basic question, but I'm new at this. I'm trying to prompt the user to select an Excel workbook, then copy and paste a range of cells from that workbook into the active one. This is my attempt below:

Please Login or Register  to view this content.

The dialog box successfully opens, and the selected file successfully opens, and then I get a run-time error 91 on the following line:

Please Login or Register  to view this content.

Again, this is probably something really stupid but all the same I need help. Thanks!

I know my eyesight is not what it used to be, but I could swear that the line you are having a problem with is not in the procedure you posted. BTW, this forum requires that you use code tags when you post macros or parts of macros. You can edit your original post, select the code portion of the post and click the pound (#) symbol to apply the code tags. It will keep the moderator from scolding you. Is there a different code that you meant to post that contains the problem line?

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Sorry about all of that! I was in a hurry last night. I did in fact post an error line from the wrong program. I have read the rules and will be sure to follow them from now on.

Good news is, I've gotten closer to my goal. I made a new program, and I'm having a new problem, but it's very much a related problem so I think I'll keep it in this same thread.

The code below is meant to copy data ranges from two different user-selected spreadsheets (wbThis an wbThat) and paste them into two different tabs of wbTarget. It is mostly working, it is prompting the user to select both workbooks, but when it's done, wbTarget has data from wbThat on both tabs, instead of wbThis on one tab and wbThat on the other. WbThis seems to be getting overwritten. Does anyone know why that might be?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The above statement is the reason it is overwriting. The code is telling it to paste data from This and That to the same range. If you want to avoid that, assuming that column A will be as lengthy with data as any of the other columns then for the That workbook data you can use:

Please Login or Register  to view this content.

Which should put the data From workbook That under the previously pasted data.

Didn't see a problem with your code except the pastespecial statement, so I modified it a bit. See if it works...

Please Login or Register  to view this content.