Hi all,

I have a spreadsheet I have created with a temporary written macro I did but now I need to make i much better but I am struggling to understand how/what the best way to write or even write this.

The Issue

A control button with the words "Copy Text"

Cell A3: Progression Update 17/08/2018
Cell A5: As this is a generic issue, until review, we anticipate this fix to be completed by the end of 2018.
Cell A7: Once we have fully reviewed this, the fix may increase reduce depending on the time and severity.

What the macro did was copy a range of cells A3 - A7. The reason why I skipped A4 and A6 was those would be my paragraph lines.
When i click my control button to "Copy Text", this would open a notepad with the correct spacing (minus the formatting).

What I am trying to do is:

1) Being able to copy the text within it's formatting as it is into memory so I can paste this into an online documentation.

I am not sure if I can put this into 1 cell and format (with font type, bold) to copy into memory.
If that is not possible, then to perhaps have a better way to copy the above?

I can provide my Macros if required (although I do believe it's a little poor in coding) as I am still learning this.

Thanks