PasteSpecial column widths with different size ranges

[Josh Sale]

If I perform:

Range("B7:E7").Copy
Range("B11:N11").PasteSpecial xlPasteFormats,
xlPasteSpecialOperationNone, False, False

Then the formatting from my four source cells is replicated across my
thirteen target cells. The first four cells are formatted, then the
second four, the third four and finally the last one. I like this
behavior.

However if instead I perform:

Range("B7:E7").Copy
Range("B11:N11").PasteSpecial xlPasteColumnWidths,
xlPasteSpecialOperationNone, False, False

I don't get the same repeating behavior across my target cells. The
first four cells get their column widths adjusted but the remaining
nine cells get no change to their column widths.

Is this a bug (I'm using XL2007)?

Can anybody think of a clever way around this short of looping? In
general I don't know in advance either the size of the source or
target ranges.

TIA,

josh

 

[JLGWhiz]

I'm guessing that if you reported it to Microsoft as a bug, they would come
back and tell you that it is by design. In one case you are applying the
entire format object of a range to another range, although larger.
In the other case you are applying a format property and it will only allow
transfer to a range of equal or smaller scope.

There are a lot of things that appear to be bugs, that are in fact by
design.