Posts by Mads_BDP

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    Hi all


    I have a piece of VBA code which take different ranges from one worksheet and pasting this in to a shape on another worksheet. My problem is that some of the ranges that I paste into the shape has to keep the source formatting - in this case the bold font type.


    Does anyone know how to keep the source formatting to make sure that the ranges that need to be bold remain bold when pasting?


    In the below code i have highlighted which ranges I want to be bold:



    Thanks


    BR Mads:)