2 Workbooks, Workbooks.Worksheets.DataBodyRange(col,row) = Value Pastes to Wrong Workbook

[Marmit424]

Hey!

Goal:
I have two workbooks open, the code sends information from one workbook to the other.

Dim tbSendTo As ListObject
Set tbSendTo = Workbooks(wbName_SendTo).Worksheets(wsName_SendTo).ListObjects(tbName_SendTo)

tbSendTo.DataBodyRange(Row, colInput) = returnValue

Problem:
The code is pasting into the wrong workbook. Despite tbSendTo referencing the correct workbook, my code is pasting back into my tbObtainFrom workbook.

Is there a way to use the DataBodyRange qualifier while keeping the reference to the proper workbook?

Thanks!!

 

[Marmit424]

Turned out it was an ID-10-T error.

Just put the wrong listobject reference identifier when I was refactoring my code.

Cheers!

Hey!

Goal:
I have two workbooks open, the code sends information from one workbook to the other.

Dim tbSendTo As ListObject
Set tbSendTo = Workbooks(wbName_SendTo).Worksheets(wsName_SendTo).ListObjects(tbName_SendTo)

tbSendTo.DataBodyRange(Row, colInput) = returnValue

Problem:
The code is pasting into the wrong workbook. Despite tbSendTo referencing the correct workbook, my code is pasting back into my tbObtainFrom workbook.

Is there a way to use the DataBodyRange qualifier while keeping the reference to the proper workbook?

Thanks!!