Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteSpecial column widths with different size ranges
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteSpecial column widths with different size ranges
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. "Josh Sale" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different widths for each column in a 100% stacked column chart | Charts and Charting in Excel | |||
Can I have different column widths below each other | New Users to Excel | |||
How do I segment a column of data into size ranges in Excel? | Excel Discussion (Misc queries) | |||
Different column widths | Excel Worksheet Functions | |||
Problem with speed of PasteSpecial for large ranges | Excel Programming |