Run Time Error 1004 - Application-defined or object-defined error

[MSIL_]

Hi Everyone,

Working on a Table with define names im having this error: Run Time Error 1004 - Application-defined or object-defined error.

im trying to do a simple record: go to the first cell(1,1) with ctrl+home shortcut , then move 2 cells to right, then ctrl+down arrow to the last cell with value and then move one cell down to the next blank cell.

when i run the macros the if i press Debug, this is what is shown:

https://cdn1.imggmi.com/uploads/2019/5/29/07daffc5cabce675e777854cd1bac626-full.jpg

 

[MSIL_]

please help.

thank you.

 

[MSIL_]

i forgot to say that im working with relative references.

Sub Macro8()'
' Macro8 Macro
'


'
    ActiveCell.Offset(-8, -8).Range("Table1[[#Headers],[Invoice Number]]").Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Range("Table1[[#Headers],[Invoice Number]]").Select
End Sub