So I have a couple lines of code,the first one's giving me trouble and the second one I know is not written correctly. I've run into this error a lot but still don't understand the overarching concept that's giving me trouble and my google searching are less than enlightening. If you can tell me what I need to do to fix my code, great, if you can give some insight into why I run into these errors and can't seem to get a hang for variable ranges in VBA, that'd be even better.

Here's the couple lines of code:

mylistend = Range(Application.ActiveWorkbook.Sheets("Meal Modules").Cells(1 + r + s, 2).End(xlDown))
                     
                        Range(Application.ActiveWorkbook.Sheets("Meal Modules").Cells(1 + r + s, 2).Offset(2, 0), & listend.Offset(0, 1) & ).Copy
And in case a little explanation helps, the first line is supposed to set "mylistend" to being the cell at the lower right hand side of a larger selection. The second line of code is supposed to copy that larger selection from the upper left to the lower right (which is now defined as 'mylistend').

Oh and the error I'm getting is "Object variable or With block variable not set."

Thanks in advance, I really appreciate it!