Object Required - Error 424

Hi there,

The goal of the macro is to copy a named range(table) from one sheet to a specific place in another sheet within the same workbook. The destination cell is bounded by some other text. Here is a sample layout (sample file also attached):

Some text

***Copied table***

Some text

The copied table can be of variable size and the "Some text" should wrap that table.

I came up with the code below but there is a problem when the following line is executed

Please Login or Register  to view this content.

However, if I uncomment the following line in the code it works fine

Please Login or Register  to view this content.

Below is the full macro code:

Please Login or Register  to view this content.

I had to use the "ugly workaround", which is commented out in a code, to make the macro work and it does what I want but I still do not understand why I get that "Object required" error.

Any help would be appreciated.

Thank you in advance,
Merdan

Your post Against Forum Rule , Please Add Code Tag first your post.

I think it should be like this...

Please Login or Register  to view this content.

Regards,

Just add below code to above that code where u have mention "Does not work here"

Please Login or Register  to view this content.

Your code deleted cel so it's not a valid range object any more.

It didn't lose scope, you deleted it.