Excel copy everything in a cell to another

Murray Brown
Murray Brown used Ask the Experts™
on
Hi
In Excel is there a way to copy everything in a cell to a new cell including comments, formatting and values?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
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
Finance Analyst
Commented:
Standard Ctrl+c to copy and  Ctrl+v tp paste will copy and paste everything including comments.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks very much
Rob HensonFinance Analyst

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial