VBA copy code that preserves formatting in the destination cell

[wylie27]

Hey all,

I currently have this code which copies data from one sheet to another. I would like to preserve the formatting of the code in the destination sheet as it has been preformatted

the code i have is

Please Login or Register  to view this content.

I have tried with no luck

Please Login or Register  to view this content.

Any hints or tips would be appreciated..

[Cutter]

@ wylie27

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

[wylie27]

its ok managed to solve this.. i changed active sheet to desitnation sheet and it worked.