VBA Update new cell with values and format

[ManUBlueJay]

I am trying to update a range of cells in my database which is an excel sheet with another input range.
The range in the database is named "MyRange". The Input Range is named "Input"

When I use this code:
Range("MyRange") = Range("Input") nothing happens

When I use:
Range("MyRange") = Range("Input").values, it updates but does not bring across my formats which includes one bold cell and 3 regular.
How can I update MyRange with the values and the formats.

 

[footoo]

Copy/PasteSpecial/Format.
The code can be obtained from the macro recorder.

 

[ManUBlueJay]

That requires sheet switching and feels clumsy.
What I have is instantaneous just missing the formats.

 

[footoo]

First get the code from the macro recorder and tweak it to avoid sheet switching.
If you don't know how to tweak it, post the code and someone will do it for you.