Setting Variable Range in VBA with .cells method

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:

Please Login or Register  to view this content.

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!

That helps monumentally! And gives me some insight into With blocks which I have yet to use.
And as to issue #2, ha, it was all originally listend but I was concerned if that was actually a command somewhere in VBA and was messing things up, guess I forgot to change them all to mylistend.

Thank you very much!