I open a workbook X
I would like to copy part of a listrow from a table from a non-active worksheet in Workbook X
When I activate the worksheet "Fin" in Workbook X
This code works
(MyCust is the Listobject in Workbook X in Worksheets Fin)
When worksheet "Fin" in Workbook Y is activated, I receive error 1004
How can I solve this problem without activating the worksheet in Workbook X
Thanks
I would like to copy part of a listrow from a table from a non-active worksheet in Workbook X
When I activate the worksheet "Fin" in Workbook X
This code works
Code:
MyCust.DataBodyRange.Range(Cells(1, 1), Cells(1, 10)).Copy
(MyCust is the Listobject in Workbook X in Worksheets Fin)
When worksheet "Fin" in Workbook Y is activated, I receive error 1004
How can I solve this problem without activating the worksheet in Workbook X
Thanks