GB wrote:

<<snipped

Incidentally, this works too
Range("E3")= Range("D3")
Is this a case of Excel assuming (helpfully) that you mean the value
property when nothing is inserted?

Yep. The default property for a range object is .value.


Incidentally, the following works

Range("E5").Font.Bold= Range("E3").Font.Bold

I can see the logic of this. You are setting the Bold property of E5's font
object equal to the value of E3's. But how do you set all of the font
properties at the same time? I thought I could use Set to make one object
equal another, so what is wrong with:

set Range("E5").font= range("E3").font

You use Set with objects and Let (or nothing) with non-objects--simple variable
type thingys.

<<snipped

--

Dave Peterson