I have a VBA macro that copies a range on a given worksheet , deletes the
copied matter from the worksheet , activates a new worksheet and pastes the

I am able to delete the selected matter from the worksheet but am simply
not able to paste the contents on the new worksheet. I get an error message
stating "object error".

Can anyone send me code that copies matter from one worksheet and pastes
it onto another one.

Thanks in advance