VBA code to paste created value into cell without changing the target's format

[Ramses505]

I am creating various values in VBA code (not copy and paste), I want to 'place' them into various cells without changing the target cells format. The target cells all have suitable formats already applied and I just want to change the values in them.

Any pointers would be most welcome.

Thanks

 

[davesexcel]

Make one range equal another range

destination_range.value=source_range.value