excel value to word bookmark - macro to keep formatting

[excelor100]

Hi all,

I lost access to my old email account so having to post for the first time again. Have always found everyone here amazingly helpful and i manage to struggle by with macros compared to most here.

I have macro which I'm using to copy a cell range 'name' in excel to a bookmark in word with the same 'name'. It works perfectly (and i can't contest to writing it all). However I'm looking for a way to keep the formatting, can anyone help?

The issue I think is that it's copying over the cell value, but this means it loses any formatting when it reaches the word bookmark. By formatting I mean decimal points etc or format of cell in % etc.

Using the cell 'name' ranges from excel is extremely helpful, as it means I can edit the excel document, add rows etc and the range name stays the same meaning I do not need to alter the macro. Whereas If i use a copy and paste macro with a keep source formatting code (which would work i think) it would need a lot of manual editing.

So I'm hoping someone may have a solution to keep the formatting with the below macro!

Any ideas hugely appreciated.

Please Login or Register  to view this content.

Thanks!

[AlphaFrog]

This will copy the numeric or date formatmatting as displayed in the cell.

Please Login or Register  to view this content.

It does not copy any font formatting like Bold, or font style, or font size.

[excelor100]

This will copy the numeric or date formatmatting as displayed in the cell.

Please Login or Register  to view this content.

It does not copy any font formatting like Bold, or font style, or font size.

Works perfectly thank you!!

Hugely appreciate your assistance Alpha frog.

[AlphaFrog]

You're welcome. Thanks for the feedback.