Keep source formatting when copying range in to shape

  • [xpost][/xpost]

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

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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!