I want a cell in one worksheet to copy a text value from another worksheet and maintain that referenced cell's text formatting. That formatting includes a change in font size within the cell and wordwrap.
Whenever I try a simple referencing it copies the text correctly but does not copy the formatting. Is there a way to do this? I'm ameneable to using VBA code if it is required.
Thanks.
Bookmarks