Posts by Mads_BDP


    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:


    BR Mads:)