Excel copy everything in a cell to another

This example has a userform that allows you to  select a range to copy then select the destination range. It will then copy all to the destination.

Check it out, if it's what you want I can add soem error handling

EDIT: I've added some error handling
CopyAll.xlsm

Thanks very much

Happy to help.

Please note, when copying a cell containing a formula and pasting to another cell, the formula cell references will adjust to the cells relative to the new location unless they are fixed with absolute references before copying.

If you wanted to paste everything apart from the formula, ie the result of the formula as a value, you can use Ctrl + v which will paste everything, including the formula, and then use Paste Special to paste the value.