Hi,

probably you need something like this:

activeworkbook.names.add name:="tbl_left", refersto:= "'" & "Inventory"
& "'!" & "A8:N" worksheets("Inventory").range("a7").End(xlDown).Ro w

If I understood your question correctly.

Regards,
Ivan