Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel copy everything in a cell to another

Hi
In Excel is there a way to copy everything in a cell to a new cell including comments, formatting and values?
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
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
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown
Murray Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks very much
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image
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.