Keep source formatting when copying range in to shape

  • 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:


    BR Mads:)

  • WElcome to Ozgrid. Please take a few minutes to read the Forum Rules to learn how to use the Forum correctly. I will add Code Tags this time.

    What's ChangeFont?

    You also need to read about cross posting!