Jump back and forth between two sheets to copy values

Hello,

I am having trouble in making this code work:

Please Login or Register  to view this content.

The error message (Object doesnt support this propety or method) occurs at the end of the code:

Please Login or Register  to view this content.

Without seeing your actual workbook and being able to test, this is my best guess at this time. You have already defined wks as a worksheet, so you do not need to name it as part of the worksheets in the workbook. It is already a variable.

Please Login or Register  to view this content.

Like I said, without seeing your workbook or a representative sample of it, it is difficult to determine what the issue is and how to fix it Also, it would be very helpful if you explained what you are trying to do instead of us trying to interpret what your non-working code is meant to do. A simple detailed explanation will go a long way to solving this.

In your line of code, excel is looking for a destination cell to paste into. You have indicated ActiveCell, however, it does not appear that you have selected an active cell in the destination. ActiveCell does not work in this situation. Is there a specific destination cell you are looking to populate. Probably need to set it up as a variable.

It would also help if there was dummy data to work with instead of blank cells. And as I indicated earlier, a brief explanation would go a long way.

I am trying to carry over the ending balance (copied sheet) to the new sheet (pasted sheet) in the beginning balance with its respective product#.
I got it with this code:

Please Login or Register  to view this content.