Error help "Select Method of Range Class Failed"

Hi guys,

Below is part of my code:

Please Login or Register  to view this content.

I'm trying to copy a range from one workbook and inserting that range into a table in another workbook, but it keeps throwing an error on line 3. Do I even need to select the body of the table to add a list row?

You can only select something on the active worksheet, which is in the active workbook. Not sure why you need to select at all, but

Please Login or Register  to view this content.

That was my thought and I tried to change it to

Please Login or Register  to view this content.

outside of the with statement but that doesn't work either.

Does the Goto line work? How are the variables declared and initialized? What error do you get?

Yes Goto did work, but it updates the screen to the selection even though I have screen Updating off. Is there a way to do this without selecting the table?

My Variables are declared and initialized in a Public Variables module that is fired at the beginning of this code.

One additional item I want the code to sort the table after inserting the new data, but the following throws an "Object doesn't support property or method."

Please Login or Register  to view this content.

Update...

.DataBodyRange.Select
only works if the destination worksheet is active. If the source worksheet is active the code fails

Originally Posted by cplettner

Update...

.DataBodyRange.Select
only works if the destination worksheet is active. If the source worksheet is active the code fails

Again, ...

Originally Posted by shg

You can only select something on the active worksheet, which is in the active workbook.

Ok is there another way to do what I am trying to do without selecting the range?

How does the code in post #3 not work?

OK now I'm really confused!!?? Norie, you must be a lucky charm! I went back to doing it that way and it worked fine, but I could have sworn it threw an error when I tried it that way before. Now that's working I need help with sorting the table. I'm using the following code to sort the table, but with no affect.

Please Login or Register  to view this content.

It throws the following error: "Application defined or Object Defined Error!"