Replica Dynamic Named Range Using a Macro

Hi Sean,

As per my previous post, I tried your updated code this evening, but again ran into an error, this time 'Object required' on the following line:

Set MyRange = Entry.Range(Range("B4"), Cells(LastRow, LastColumn))

Also as requested, I have attached my Excel Workbook that contains the scenario that I am trying to address, plus the macros that you provided. Perhaps you can run the second one and see where I am experiencing the issue.

Hopefully, the attached Workbook will help clarify what I am trying to address. To clarify further, the following is the intent:

The attached Excel Workbook includes my 'Entry' Worksheet with the 'Tasks' Named Range defined along with the 'Dataset' Worksheet that contains two versions of the linked Named Range ('Task_Data1' and 'Task_Data2'), to illustrate that the replication process using an array or an 'Index' formula is working (that is, I can replicate the 'Tasks' Named Range from the 'Entry' Worksheet).

However, what I can't get to work is the dynamic expansion of either the 'Task_Data1' or the 'Task_Data2' Named Ranges, when I copy and paste a row in the 'Tasks' Worksheet within the green dotted lines (my Named Ranged called 'Tasks').

When I look at the 'Name Manager' information after copying and inserting a row within the green dotted lines, I see that the 'Tasks' Named Range has been extended. My real need is a way of automatically expanding the 'Task_Data1' or 'Task_Data2' Named Ranges in the 'Dataset' Worksheet.

That's where I'm hoping your macros can be of assistance. An explanation on how they can be leveraged to address this dynamic expansion of the target 'Task_Data1' or 'Task_Data2' Named Ranges would be a big help.

Cheers,

Wayne